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#
