|
ALTER SESSION SET EVENTS ''''10393 trace name context forever, level 1'''';
Event 10500 - Trace SMON Process--在init.ora中做
event = "10500 trace name context forever, level 1"
Event 10608 - Trace Bitmap Index Creation—跟踪二位图索引
ALTER SESSION SET EVENTS ''''10608 trace name context forever, level 10'''';
Event 10704 - Trace Enqueues—跟踪队列
ALTER SESSION SET EVENTS ''''10704 trace name context forever, level 1'''';
Event 10706 - Trace Global Enqueue Manipulation-(参考http://www.juliandyke.com/)
ALTER SESSION SET EVENTS ''''10706 trace name context forever, level 1'''';
Event 10708 - Trace RAC Buffer Cache—跟踪RAC的Buffer Cache
ALTER SESSION SET EVENTS ''''10708 trace name context forever, level 10'''';
Event 10710 - Trace Bitmap Index Access--(参考http://www.juliandyke.com/)
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—
ALTER SESSION SET EVENTS ''''10714 trace name context forever, level 1'''';
Event 10715 - Trace Bitmap Index Conversion to ROWIDs Operation—
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—
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—
ALTER SESSION SET EVENTS ''''10731 trace name context forever, level level'''';
Levels are:
Level
Action
1
Print parent query and subquery
2
Print subquery only
Event 10928 - Trace PL/SQL Execution—
ALTER SESSION SET EVENTS ''''10928 trace name context forever, level 1'''';
Event 10938 - Dump PL/SQL Execution Statistics—
ALTER SESSION SET EVENTS ''''10938 trace name context forever, level 1'''';
一些其他的Events：
ALTER SESSION SET EVENTS ''''immediate trace name flush_cache'''';--Flush the Buffer cache
资料来源http://www.juliandyke.com/
以上为个人在做DBA时的一些参考资料.
上一页 [1] [2] [3] [4]
[系统软件]EXP-00008: ORACLE error 904 encountered的解决方… [常用软件]PB7 连接 Oracle 的配置方法
[Web开发]oracle Export and Import 简介 [Web开发]ADO访问Oracle结果集的心得
[JAVA开发]JDBC+Hibernate将Blob数据写入Oracle [JAVA开发]J2EE应用中与Oracle数据库的连接
[JAVA开发]Oracle Application Serve_ [其他]HP-UXrx2600B.11.22Uia64安装oracle9i9.2foria64手…
[其他]在RedhatEnterpriseserver3上安装oracle9iR2的注意… [其他]PROC＋＋批量导入导出ORACLE数据库表
| 
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
