xinxiangsui2008的专栏

Oracle 10046是一个Oracle内部事件。最常用的是在Session级别设置sql_trace(alter session set sql_trace=true)即是开启了级别为1的10046调试事件。当设置了10046事件之后，Oracle 将产生一个dump文件。通过得到的dump文件进行进一步分析，可以得到Oracle 内部执行系统解析、调用、等待、绑定变量等详细的trace信息，

Displays a report on the execution of successful SQL DML statements (SELECT, INSERT, UPDATE or DELETE). 用法: SET AUTOT[RACE] {OFF | ON | TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]] 一、启用Autotrace功能 启用前

APPLIES TO: Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.2.0.3 [Release 8.1.7 to 11.2] Information in this document applies to any platform. ***Checked for relevance on 26-Apr-2012*

***Checked for relevance on 12-Jun-2012*** How to Enable SQL_TRACE for Another Session Using ORADEBUG: =========================================================== The ORADEBUG utility can enable/d