Select distinct
a.sql_text,b.event,b.logon_time,b.username,a.CPU_TIME/1000/a.executions "cpu
ms",b.event#,b.sid,b.serial#,b.service_name,b.module "应用程序" ,c.value,d.name
from v$sqlarea
a,v$session b,V$SESStat c,v$statname d where a.sql_id=b.sql_id and b.sid=c.sid and c.STATISTIC# =
d.STATISTIC# and b.status = 'ACTIVE' and b.event not in('SQL*Net message from client','SQL*Net message to
client','SQL*Net more data
to client','client message','virtual circuit
status','parallel query idle
wait - Slaves',' parallel query
dequeue wait','lock element
cleanup','dispatcher timer','pmon timer- pmon','rdbms ipc message','Space Manager:
slave idle wait') order by b.logon_time desc;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29065182/viewspace-1079440/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29065182/viewspace-1079440/