How to use sql_trace,10046 events and tkprof

alter session set timed_statistics=true;

alter session set sql_trace=true;

alter session set  events '10046 trace name context  forever,level 12';

alter session set tracefile_identifier='look_for_me';

your sql statement;

alter session set sql_trace=false;

ll /opt/oracle10g/admin/ORCL/udump/*look_for_me;

alter session set timed_statistics=true;

alter session set sql_trace=true;

alter session set tracefile_identifier='look_for_me';

your sql statement;

alter session set sql_trace=false;

tkprof  orcl_ora_4415_look_for_me.trc  tkprof_rep1.txt;

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

转载于:http://blog.itpub.net/230160/viewspace-592427/