ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle常用EVENT参考(三)

Oracle常用EVENT参考(三)

原创 Linux操作系统 作者:xuelu2000 时间:2009-04-04 23:11:50 0 删除 编辑

转载:http://hi.baidu.com/edeed/blog/item/394e19d885ca743132fa1c59.html

事件

说明

例子

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#

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/95233/viewspace-584663/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-03-23

  • 博文量
    89
  • 访问量
    238373