Event 10710 - Trace Bitmap Index Access

跟蹤點陣圖索引的訪問情況

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

跟蹤點陣圖索引minus操作

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

Event 10715 - Trace Bitmap Index Conversion to ROWIDs Operation

跟蹤點陣圖索引轉換ROWID操作

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

跟蹤點陣圖索引列的DML操作（引起點陣圖索引改變的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

跟蹤CURSOR的語句情況

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

LEVEL定義

1 Print parent query and subquery

2 Print subquery only

Event 10928 - Trace PL/SQL Execution

跟蹤PL/SQL執行情況

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

Event 10938 - Dump PL/SQL Execution Statistics

跟蹤PL/SQL執行狀態。使用前需要執行rdbms/admin下的tracetab.sql

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

flush_cache

重新整理BUFFER CACHE

ALTER SESSION SET EVENTS 'immediate trace name flush_cache';

DROP_SEGMENTS

手工刪除臨時段。當這些臨時段無法自動清除的時候可以手工清除

alter session set events 'immediate trace name DROP_SEGMENTS level ts#+1';

ts#是指要刪除臨時段的表空間的ts#

【Oracle】Oracle常用EVENT之三

相關文章