【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#