查看Oracle长时间运行操作（V$SESSION_LONGOPS）

SET LINESIZE 1000
SET PAGESIZE 1000
ALTER SESSION SET NLS_DATE_FORMAT = "YYYY/MM/DD HH24:MI:SS";
ALTER SESSION SET NLS_TIMESTAMP_FORMAT = "YYYY/MM/DD HH24:MI:SSXFF";
COLUMN SID FORMAT 999999
COLUMN SERIAL# FORMAT 9999999
COLUMN MESSAGE FORMAT A100




SELECT
SID,
SERIAL#,
START_TIME,
round((SOFAR  TOTALWORK * 100), 2) "PROGRESS(%)",
TIME_REMAINING,
ELAPSED_SECONDS,
MESSAGE
FROM
V$SESSION_LONGOPS
WHERE
-- 未结束的会话
TIME_REMAINING != 0 OR
-- 1小时内结束的会话
(START_TIME + ELAPSED_SECONDS  86400) > (sysdate - 1  24)
order by TIME_REMAINING desc, START_TIME desc, 1, 2
;
复制