===========================================================
ҵprocedurereferenceĶ
===========================================================
ѯuser_dependenciesԡ磺
select * from user_dependencies where name ='P_AUTO_DROP_OTHERDATA' and referenced_type='TABLE' order by referenced_name;
xsb
:2009.04.03 11:19
:::
(
Oracle
)
::Ķ:(150)
::
(1)
::
(0)
===========================================================
profiler
===========================================================
CONNECT sys/password@service AS SYSDBA
@$ORACLE_HOME/rdbms/admin/profload.sql
CONNECT profiler/profiler@service
@$ORACLE_HOME/rdbms/admin/proftab.sql
xsb
:2009.02.20 16:43
:::
(
Oracle
)
::Ķ:(136)
::
(0)
::
(0)
===========================================================
Oracle11g RMAN Duplicate from Active Database
===========================================================
RmanduplicateԺܷĽԭ⸴Ƴһ¿⣬data guardӦзdzáOracle11g֮ǰִduplicateҪȶԭrmanбݣȻݸƵƿ⣬ͬʱԭ(Ϊtarget)ƿ(Ϊauxiliary)ִduplicateиơOracle11gƳactive database duplicateԣʡ˽rmanݵIJ裬ֱܹӴԭ⸴Ƴ¿⣬һЩ͵ݿ˵ԿԽʡܶʱ䡣Ľʾһ²(ͬһִduplicate)
鿴ȫ
xsb
:2009.01.06 13:58
:::
(
Oracle
)
::Ķ:(259)
::
(0)
::
(0)
===========================================================
oracle11g pivot ת SQL Server 2005
===========================================================
Oracle ݿ 11g Ƴ֮ǰҪÿֵͨʹdecode caseת
ÿֵͬдΪһСǣ÷ǺֱܲҲǺܷ㡣
oracle11gʹһֺܺõPIVOTUNPIVOT,ͨһµIJԽʽʾκβѯ
oracleΪʵָǿݲֿӦãSQLPL/SQLкܴļǿ SQL Server2005˺ܶӭϿ߿ζԣȻĶȴ˼˿ߵĹûǵĿ˼·ֵóޡ
鿴ȫ
xsb
:2009.01.06 13:42
:::
(
Oracle
)
::Ķ:(294)
::
(0)
::
(0)
===========================================================
TimesTen
===========================================================
http://www.ttisql.com/
Oracleһ汾(2009)TIMESTEN֧PL/SQL֧OCIPRO*CʱƽûҪĿǰ7.0.5ӹϽȻԴΧռע°汾
xsb
:2008.12.22 14:00
:::
(
Oracle
)
::Ķ:(411)
::
(4)
::
(0)
===========================================================
oracle develop 2008 APEX & SQL developer
===========================================================
20081210--11գĿߴ2008½йܲMichael HichwañOracleݿӦóٿᣬƹݿӦóߡ
ƷֱΪOracle SQL DeveloperOracle Application ExpressƷĿǰΪṩûʹõģĿǼʹOracleݿӦóḶ́ݿӦóĿЧʡƷһƳͱܳԱOracleݿʹǵݳȫѾʹ
鿴ȫ
xsb
:2008.12.13 15:33
:::
(
Oracle
)
::Ķ:(410)
::
(5)
::
(0)
===========================================================
APEX installation
===========================================================
- Oracle RDBMS 10.2.0.3.0 (Enterprise Edition) and/of higher version
- APEX 3.1.2
- Windows 2003 / XP
鿴ȫ
xsb
:2008.12.12 22:14
:::
(
Oracle
)
::Ķ:(376)
::
(4)
::
(0)
===========================================================
forall bulk collect
===========================================================
Bulk bindsͨPL/SQLSQL֮л(context switches ).
Bulk binds
(i) Input collections, use the FORALL statementһDMLINSERTUPDATEDELETE)
(ii) Output collections, use BULK COLLECT clauseһ߲ѯSELECT
10gʼforallʹַʽ
i in low..up
i in indices of collection ȡüԪ±ֵ
i in values of collection ȡüԪصֵ
forall仹ʹòּԪ
sql%bulk_rowcount(i)ʾforalliԪõ
鿴ȫ
xsb
:2008.12.09 14:29
:::
(
Oracle
)
::Ķ:(277)
::
(0)
::
(0)
===========================================================
dbms_utility.compile_schema
===========================================================
±ORACLEݿЧexec dbms_utility.compile_schema('TEST',false,false);
xsb
:2008.12.08 09:54
:::
(
Oracle
)
::Ķ:(217)
::
(1)
::
(0)
===========================================================
dbms_utility.comma_to_table[zt]
===========================================================
xsb
:2008.12.08 09:36
:::
(
Oracle
)
::Ķ:(223)
::
(0)
::
(0)
===========================================================
Oracle 11g:Result Cache֮һ[zt]
===========================================================
Oracle Database 11gУOracleһ˹עԣ棨Result Cache
һResult CacheֿԷΪServer Result Cache Client Result Cache
ǰͨSGAͨͻ
Ref: http://www.eygle.com/archives/2007/09/11g_result_cache.html
Oracle 11g:Server Result Cache[zt]
Ref:http://www.eygle.com/archives/2007/09/11g_server_result_cache.html
Oracle11g-PLSQLһ[zt]
鿴ȫ
xsb
:2008.12.04 16:23
:::
(
Oracle
)
::Ķ:(252)
::
(0)
::
(0)
===========================================================
sqlplusspoolɴڵļ
===========================================================
sqlplusspoolɴڵļcol spf new_value spf noprint
select 'd:'||to_char(sysdate,'yyyymmdd')||'.txt' spf from dual;
spo &spf select * from dual;
spo off; 鿴ȫ
xsb
:2008.09.05 09:19
:::
(
Oracle
)
::Ķ:(562)
::
(0)
::
(0)
===========================================================
10gбstatistics_level
===========================================================
10g֮ǰİ汾,dbms_statsALTER_DATABASE/SCHEMA_TAB_MONITORING̻create/alter table ... monitoringļ,10g,MONITORINGNOMONITORINGؼѾʱ,create/alter tableָļػȡ,ùؼֽ,statistics_level,statistics_levelbasicʱ,ֹļ,typicalallʱ,Ǽ.
鿴ȫ
xsb
:2008.08.25 14:10
:::
(
Oracle
)
::Ķ:(389)
::
(0)
::
(0)
===========================================================
رռoracle10gͳϢԶռ
===========================================================
ֱַ£һ
SYSDBA¼
exec dbms_scheduler.disable('SYS.GATHER_STATS_JOB');
exec dbms_scheduler.enable('SYS.GATHER_STATS_JOB');
alter system set "_optimizer_autostats_job"=false scope=spfile;
alter system set "_optimizer_autostats_job"=true scope=spfile;
Pfileֱijʼļ
Ȼݿ⡣
xsb
:2008.07.25 14:28
:::
(
Oracle
)
::Ķ:(370)
::
(0)
::
(0)
===========================================================
Oracle10G EM dbcontrol
===========================================================
emca -config dbcontrol db -repos create
emca -deconfig dbcontrol db -repos drop
emctl status dbconsole
鿴ȫ
xsb
:2008.07.18 22:38
:::
(
Oracle
)
::Ķ:(275)
::
(0)
::
(0)
===========================================================
ora11g install on ora_eLinux5u2
===========================================================
oraLinux5U2°װORACLE11G.
鿴ȫ
xsb
:2008.07.18 19:15
:::
(
Oracle
)
::Ķ:(269)
::
(3)
::
(0)
===========================================================
ora10g install on RHAS4
===========================================================
ora10g install on RHAS4 step by step .
鿴ȫ
xsb
:2008.07.18 19:12
:::
(
Oracle
)
::Ķ:(228)
::
(0)
::
(0)
===========================================================
Sql Server 2005T-sql
===========================================================
xsb
:2008.07.15 11:50
:::
(
SQLserver
)
::Ķ:(256)
::
(0)
::
(0)
===========================================================
SQL Server õSQLT-SQL
===========================================================
xsb
:2008.07.15 11:49
:::
(
SQLserver
)
::Ķ:(222)
::
(0)
::
(0)
===========================================================
SQL Server 2005 Beta 2 ո
===========================================================
xsb
:2008.07.14 14:37
:::
(
SQLserver
)
::Ķ:(187)
::
(0)
::
(0)