使用TKPROF工具获取跟踪信息
使用SQLPLUS连接一个会话
alter session set timed_statistics=true;
alter session set events '10046 trace name context forever,level 12';
select count(*) from big_table;
select * from big_table where owner='SYS' and object_name like 'F%' where rownum<5;
alter session set events '10046 trace name context off';
获取跟踪文件名
select rtrim(c.value,'/') || '/' || d.instance_name || '_ora_' || ltrim(to_char(a.spid)) || '.trc'
from v$process a,v$session b,v$parameter c,v$instance d
where a.addr=b.paddr
and b.audsid=sys_context('userenv','sessionid')
and c.name='user_dump_dest'
/
此时需要退出SQL*PLUS环境，才能完全关闭跟踪文件，是跟踪文件所有信息都可用。
创建TKPROF报告
tkprof /u01/app/oracle/diag/rdbms/eisoo/eisoo/trace/eisoo_ora_16662.trc tk1.prf
alter session set timed_statistics=true;
alter session set events '10046 trace name context forever,level 12';
select count(*) from big_table;
select * from big_table where owner='SYS' and object_name like 'F%' where rownum<5;
alter session set events '10046 trace name context off';
获取跟踪文件名
select rtrim(c.value,'/') || '/' || d.instance_name || '_ora_' || ltrim(to_char(a.spid)) || '.trc'
from v$process a,v$session b,v$parameter c,v$instance d
where a.addr=b.paddr
and b.audsid=sys_context('userenv','sessionid')
and c.name='user_dump_dest'
/
此时需要退出SQL*PLUS环境，才能完全关闭跟踪文件，是跟踪文件所有信息都可用。
创建TKPROF报告
tkprof /u01/app/oracle/diag/rdbms/eisoo/eisoo/trace/eisoo_ora_16662.trc tk1.prf
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30373263/viewspace-2072662/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
