as.sql
現在実行中のSQL情報を表示する
code:SQL
break on MON_CMD skip page
set lines 2000
set pages 100
col "SQL_TEXT(300 Byte)" for a75
col MON_CMD for a20
col INST_ID for a8
col CHILD_NUMBER for a4 heading "CNO"
col MODULE for a30
col WAIT_CLASS for a20
col EVENT for a30
col SCHEMANAME for a11
col ELAP_SEC for 999,999,990.00
col ELAP_PER_EXEC for 999,999,990.00
select
SUBSTR(B.SQL_TEXT,1,300) AS "SQL_TEXT(300 Byte)",
'@mon ' ||B.SQL_ID || ' ' || to_char(A.INST_ID) MON_CMD,
B.SQL_ID,
to_char(B.CHILD_NUMBER) CHILD_NUMBER,
A.LAST_CALL_ET,
A.STATUS,
B.ELAPSED_TIME/1000000 ELAP_SEC,
B.ELAPSED_TIME/1000000/decode(B.EXECUTIONS,0,1,B.EXECUTIONS) ELAP_PER_EXEC,
A.SID,
A.SERIAL#,
A.SCHEMANAME,
A.MODULE,
A.WAIT_CLASS,
A.EVENT,
B.EXECUTIONS,
B.BUFFER_GETS --,
-- B.ROWS_PROCESSED
from
GV$SESSION A,
GV$SQL B
where
A.SQL_ID = B.SQL_ID AND
A.INST_ID = B.INST_ID AND
A.WAIT_CLASS != 'Idle' and
B.SQL_TEXT not like 'select SUBSTR(B.SQL_TEXT%' and
B.ELAPSED_TIME/1000000 < 1000
order by A.SCHEMANAME,B.SQL_ID,B.ELAPSED_TIME;
@default_settings