oracle数据库查看正在执行的sql_trace
1.
select a.program,b.spid,c.sql_text from v$session a,v$process b,v$sqlarea c where a.paddr=b.addr and a.sql_hash_value=c.hash_value and a.username is not null;
2.
select a.osuser,a.SID, a.program, b.spid, c.SQL_FULLTEXT,to_char(a.LOGON_TIME,'yyyy-mm-dd hh24:mi;ss')from v$session a, v$process b, v$sqlarea c
where a.paddr = b.addr
and a.sql_hash_value = c.hash_value
and a.username is not null
3.
获得当前trace文件生成路径select tracefile
from v$process
where addr in
(select paddr from v$session where sid in (select sid from v$mystat));