alter session set max_dump_file_size=unlimited;
alter session set timed_statistics=true;
alter session set events '10046 trace name context forever, level 12';
select 'Hello, world; today is '||sysdate from dual;
exit;
tkprof card_ora_13226.trc trace.txt print=100 record=sql.txt sys=no
然后查年trace.txt就是分析内容了
posted on 2007-11-06 09:52
liunix 阅读(371)
评论(0) 编辑 收藏