실시간 수행중인 Query 바인드 변수 확인

--실행중인 쿼리 바인드변수 확인 (3초이상)

 

SELECT sid
     , LEVEL AS bind_val, REPLACE(SUBSTR(REPLACE(SUBSTR(data,INSTR(data,'|',1,LEVEL),DECODE(INSTR(data,'|',1,LEVEL+1),0,128,INSTR(data,'|',1,LEVEL+1) - INSTR(data,'|',1,LEVEL))),'|'),instr(REPLACE(SUBSTR(data,INSTR(data,'|',1,LEVEL),DECODE(INSTR(data,'|',1,LEVEL+1),0,128,INSTR(data,'|',1,LEVEL+1) - INSTR(data,'|',1,LEVEL))),'|'),'>')+1),'</bind>','') AS value
FROM
(
    SELECT data, sid
         , LENGTH(data) - LENGTH(REPLACE(data,'|')) cnt 
    FROM
    (
       SELECT sid, REPLACE(REPLACE(REPLACE((binds_xml),'<binds>',''),'</binds>',''),'<bind name','|') AS data 
       FROM V$sql_monitor
       WHERE sql_id = '7sr5sn76d8vd4' 
       AND      sid = '4152'
       AND   status = 'EXECUTING'
    )
) CONNECT BY LEVEL <= cnt
ORDER BY bind_val
;