查询active sql
<DIV>SET LINES 165 PAGES 100<BR>COL SID FOR 9999<BR>COL SERIAL# FOR 99999<BR>COL CHD FOR A2<BR>COL EVENT FOR A18<BR>COL SQL_TEXT FOR A61<BR>COL USERN FOR A6<BR>COL SEC FOR 9999.999<BR>COL C_SEC FOR 9999.999<BR>COL EXEC FOR 999999<BR>COL DISKS FOR 99999.99<BR>COL SPID FOR A5<BR>COL LCE FOR 99999<BR>SELECT d.spid spid,<BR>--a.sid,a.SERIAL#,<BR>a.last_call_et lce,substr(a.UserName,1,6) usern<BR>,substr(c.sql_text,1,60) sql_text <BR>--,c.sql_text sql_text<BR>,(case when c.EXECUTIONS=0 then round(c.CPU_TIME/1000000,3)<BR> when c.EXECUTIONS<>0 then round(c.CPU_TIME/(c.EXECUTIONS*1000000),3) end) c_sec<BR>,(case when c.EXECUTIONS=0 then round(c.ELAPSED_TIME/1000000,3)<BR>when c.EXECUTIONS<>0 then round(c.ELAPSED_TIME/(c.EXECUTIONS*1000000),3) end) sec<BR>,(case when c.EXECUTIONS=0 then round(c.DISK_READS,2)<BR>when c.EXECUTIONS<>0 then round(c.DISK_READS/c.EXECUTIONS,2) end) disks<BR>,EXECUTIONS exec<BR>,substr(b.EVENT,0,18) event ,c.hash_value <BR>--,c.sql_id<BR>,to_char(c.child_number) chd<BR>FROM v$session a, v$session_wait b, v$sql c, v$process d<BR>WHERE a.sid=b.sid AND d.addr=a.paddr<BR> AND a.SQL_HASH_VALUE=c.HASH_VALUE <BR> AND a.STATUS='ACTIVE'<BR> AND c.last_load_time IN (SELECT max(w.last_load_time) FROM v$sql w WHERE w.hash_value=c.hash_value)<BR><BR></DIV>
页:
[1]