oracle 查看正在执行的sql_trace

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));