Event 10500 - Trace SMON Process--在init.ora中做

                event = "10500 trace name context forever, level 1"

Event 10608 - Trace Bitmap Index Creation—跟踪二位图索引

             ALTER SESSION SET EVENTS ''''10608 trace name context forever, level 10'''';

Event 10704 - Trace Enqueues—跟踪队列

            ALTER SESSION SET EVENTS ''''10704 trace name context forever, level 1'''';

Event 10706 - Trace Global Enqueue Manipulation-(参考http://www.juliandyke.com/)

           ALTER SESSION SET EVENTS ''''10706 trace name context forever, level 1'''';

Event 10708 - Trace RAC Buffer Cache—跟踪RAC的Buffer Cache

           ALTER SESSION SET EVENTS ''''10708 trace name context forever, level 10'''';

Event 10710 - Trace Bitmap Index Access--(参考http://www.juliandyke.com/)

           ALTER SESSION SET EVENTS ''''10710 trace name context forever, level 1'''';

Event 10711 - Trace Bitmap Index Merge Operation—

            ALTER SESSION SET EVENTS ''''10711 trace name context forever, level 1'''';

Event 10712 - Trace Bitmap Index OR Operation—

           ALTER SESSION SET EVENTS ''''10712 trace name context forever, level 1'''';

Event 10713 - Trace Bitmap Index AND Operation—

          ALTER SESSION SET EVENTS ''''10713 trace name context forever, level 1'''';

Event 10714 - Trace Bitmap Index MINUS Operation—

          ALTER SESSION SET EVENTS ''''10714 trace name context forever, level 1'''';

Event 10715 - Trace Bitmap Index Conversion to ROWIDs Operation—

           ALTER SESSION SET EVENTS ''''10715 trace name context forever, level 1'''';

Event 10716 - Trace Bitmap Index Compress/Decompress—

           ALTER SESSION SET EVENTS ''''10716 trace name context forever, level 1'''';

Event 10717 - Trace Bitmap Index Compaction—

             ALTER SESSION SET EVENTS ''''10717 trace name context forever, level 1'''';

Event 10719 - Trace Bitmap Index DML—

            ALTER SESSION SET EVENTS ''''10719 trace name context forever, level 1'''';

Event 10730 - Trace Fine Grained Access Predicates—

           ALTER SESSION SET EVENTS ''''10730 trace name context forever, level 1'''';

Event 10731 - Trace CURSOR Statements—

             ALTER SESSION SET EVENTS ''''10731 trace name context forever, level level'''';

Levels are:

Level

Action

1

Print parent query and subquery

2

Print subquery only

Event 10928 - Trace PL/SQL Execution—

          ALTER SESSION SET EVENTS ''''10928 trace name context forever, level 1'''';

Event 10938 - Dump PL/SQL Execution Statistics—

          ALTER SESSION SET EVENTS ''''10938 trace name context forever, level 1'''';

一些其他的Events：

ALTER SESSION SET EVENTS ''''immediate trace name flush_cache'''';--Flush the Buffer cache

资料来源http://www.juliandyke.com/

以上为个人在做DBA时的一些参考资料.

上一页  [1] [2] [3] [4]