SELECT S.USERNAME,
S.SID,
S.SERIAL#,
S.INST_ID,
S.EVENT,
'exec kill_session('||sid||','||serial#||');',
S.WAIT_CLASS,
S.SQL_EXEC_START,
S.LOGON_TIME,
S.ACTION,
SQ.SQL_TEXT,
S.MACHINE
FROM GV$SESSION S, GV$SQLAREA SQ
WHERE S.STATUS = 'ACTIVE'
AND S.USERNAME IS NOT NULL
AND S.SQL_ID = SQ.SQL_ID
and S.EVENT like '%dblink%'
ORACLE数据库DBLINK进程卡死,相关解决SQL
最新推荐文章于 2024-08-12 15:58:26 发布