?? 注意：查詢條件，需要輸入 SPID ！
set linesize 260set pagesize 1000col sid for 99999col spid for a8 col event for a30 col module for a35 col machine for a15 col username for a10 col holder for a10 col final for a10 col sql_id for a15 col exec_gets for 99999999col seconds for a5 col object_id for 999999col param for a30 col sql_text for a6 col PGA_USE for 9999alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';select a.sid, a.username, a.machine, a.module, a.event, a.sql_id, round(decode(c.executions,0,buffer_gets,buffer_gets/executions)) exec_gets, a.ROW_WAIT_OBJ# object_id, a.BLOCKING_INSTANCE||'_'||a.blocking_session holder, a.FINAL_BLOCKING_INSTANCE||'_'||a.FINAL_BLOCKING_SESSION final, to_char(LAST_CALL_ET) seconds, a.p1 || '_' || a.p2 || '_' || a.p3 param, b.spid, trunc(b.PGA_USED_MEM / 1024 / 1024,2) as PGA_USE, substr(c.sql_text,0,6) sql_text from v$session a, v$process b,v$sql c where a.paddr = b.addr(+) and a.status = 'ACTIVE' and not (a.type = 'BACKGROUND' and a.state = 'WAITING' anda.wait_class = 'Idle') and a.sql_id=c.sql_id(+) and a.sql_child_number=c.CHILD_NUMBER(+) and b.spid='&SPID' order by a.sql_id, a.machine;
本次分享到此結(jié)束啦~
如果覺得文章對你有幫助，點贊、收藏、關(guān)注、評論，一鍵四連支持，你的支持就是我創(chuàng)作最大的動力。
