【Oracle】Oracle常用EVENT之三

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#