oracle event 2 (zt)

zhouwf0726發表於2019-07-02
Oracle
Level參考

Level

Action

0x0001

Dump pruning descriptor for each partitioned object

0x0002

Dump partition iterators

0x0004

Dump optimizer decisions about partition-wise joins

0x0008

Dump ROWID range scan pruning information

在9.0.1或者後面的版本,在level 2後還需要建立如下的表:

CREATE TABLE kkpap_pruning
    (
            partition_count    NUMBER,
            iterator           VARCHAR2(32),
            partition_level      VARCHAR2(32),
              order_pt             VARCHAR2(12),
            call_time               VARCHAR2(12),
           part#               NUMBER,
            subp#              NUMBER,
            abs#               NUMBER
       );

Event 10200 - Dump Consistent Reads---Dump出一致讀的資訊

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

Event 10201 - Dump Consistent Read Undo Application---(不明白)

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

Event 10220 - Dump Changes to Undo Header—Dump出Undo頭資訊的改變

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

Event 10221 - Dump Undo Changes—Dump Undo的改變

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

Event 10224 - Dump Index Block Splits / Deletes—Dump索引塊的Split和Delete資訊

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

Event 10225 - Dump Changes to Dictionary Managed Extents---Dump出在Row Cache中,字典管理的Extents的改變

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

Event 10231--設定在做全表掃描時跳過損壞的資料塊（在做EXP時，如果有壞塊，設定這個可以使EXP匯出時跳過壞塊，使得部分資料能可以使用）

         ALTER SYSTEM SET EVENTS '10231 trace name context forever,level 10';

Event 10241 - Dump Remote SQL Execution—Dump遠端SQL語句的執行資訊

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

Event 10246 - Trace PMON Process---只能在init.ora中做,不能用ALTER SYSTEM做

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

Event 10248 - Trace Dispatcher Processes---在init.ora中做(9iDump到udump目錄中)

            event = "10248 trace name context forever, level 10"

Event 10249 - Trace Shared Server (MTS) Processes---在init.ora中做(9iDump到udump目錄中)

              event = "10249 trace name context forever, level 10"

Event 10270 - Debug Shared Cursors—(不明白)

event = "10270 trace name context forever, level 10"

Event 10299 - Debug Prefetching---(參考http://www.juliandyke.com/)

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

 

Event 10357 - Debug Direct Path---(參考http://www.juliandyke.com/)

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

Event 10390 - Dump Parallel Execution Slave Statistics--(參考http://www.juliandyke.com/)

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

Event 10391-Dump Parallel Execution Granule Allocation---

                                 (參考http://www.juliandyke.com/)

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

Event 10393 - Dump Parallel Execution Statistics--(參考http://www.juliandyke.com/)

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

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/

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/756652/viewspace-343395/，如需轉載，請註明出處，否則將追究法律責任。

相關文章