0> conn /as sysdba;
1> 激活10046
alter session set events ‘10046 trace name context forever,level 12’
oradebug event 10046 trace name context forever,level 12
2> oradebug setmypid –準備目前session使用oradebug指令
3》要執行的sql
select empno,ename,dname from scott.emp,scott.dept where
emp.deptno=dept.deptno;
4> oradebug tracefile_name –檢視生成的事件檔案路徑
5》分析
consistent reads—cr
physical reads–pr
cardinality–card
c:\users\administrator>tkprof c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_2788.trc e:\orcl_ora_tkprof_2788;
alter session set events ‘10046 trace name context off’
oradebug event 10046 trace name context off