http://dbakevin.blogspot.mx/2012/04/event-single-task-message-and-dblink.html Got one task, need to execute one script in DB. Before execution, i went through the script once. The script is simple, ...

IMU是10g引入的一项新技术，并且是Oracle的专利技术。但是，在10g中似乎没有完全激活，以下的测试在2.0.3中无法通过，在11g中可以进行。 在传统的事务更新过程中，如果一条数据记录被更新，就会从buffer cache ...

今早上检查rac系统crs_stat -t -v 发现实例2、lsnr、asm offline 了 [oracle@rac2 racg]$ crs_stat -t -v Name Type R/RA F/FT Target State Host -------------------------------- ...

上一篇文章已经介绍了采用带CONNECT语句的方式备份，这里介绍对应的恢复方法。首先备份并删除上次全备份以来的归档日志，然后准备开始恢复：RMAN> run 2> { 3> allocate channel c1 device type disk format '/data1 ...

•Trace Location 11g R1 and above: With the introduction of the new diagnosability infrastructure introduced in Oracle Database 11g Release 1, traces and core files are placed in a location control ...

http://dbakevin.blogspot.mx/2012/04/mv-refresh-cost-long-time-due-to.html We have a job defined to do mutiple MV refresh. Most MVs can refresh normally, but there are two MVs cost very long time to c ...

1. Viewing Enabled Traces You can query DBA_ENABLED_TRACES to determine what traces are enabled. Example: SQL> select trace_type, primary_id, QUALIFIER_ID1, waits, binds from DBA_ENABLE ...

Pre-requisites for successful tracing Set TIMED_STATISTICS to TRUE. Set MAX_DUMP_FILE_SIZE to a high value or œunlimited. Tracing the Current Session 1.SQL_TRACE To start tracing: ALTER SESSION ...