10G
--10g及以后版本
select distinct b.SID,b.SERIAL#,p.SPID,b.LAST_CALL_ET,a.sql_id, a.sql_text,b.status,b.event,b.MODULE, b.OSUSER,b.MACHINE from v$sql a,v$session b,v$process p where a.SQL_ID=b.SQL_ID and b.PADDR=p.ADDR and b.STATUS='ACTIVE' order by B.LAST_CALL_ET desc;
--9i及以后版本
select distinct b.SID,
b.SERIAL#,
p.SPID,
b.LAST_CALL_ET,
a.sql_text,
b.status,
--b.event,
b.MODULE,
b.OSUSER,
b.MACHINE
from v$sql a, v$session b, v$process p
where a.ADDRESS = b.SQL_ADDRESS
and b.PADDR = p.ADDR
and b.STATUS = 'ACTIVE'
order by B.LAST_CALL_ET desc;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28572479/viewspace-2123972/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28572479/viewspace-2123972/