查看长时间会话 select SID, SERIAL#, (select P.SPID from GV$SESSION S join GV$PROCESS P on P.ADDR = S.PADDR and P.INST_ID = S.INST_ID where S.TYPE != 'BACKGROUND' and S.SID = T1.SID and S.SERIAL# = T1.SERIAL#) SPID, USERNAME, (select SQL_FULLTEXT from SYS.V$SQLAREA T3 where T1.SQL_ID = T3.SQL_ID) SQL_FULLTEXT, OPNAME, TARGET, (select ROUND(sum(BYTES) / 1024 / 1024, 2) from SYS.DBA_SEGMENTS T2 where T2.OWNER || '.' || SEGMENT_NAME = T1.TARGET group by T2.OWNER || '.' || SEGMENT_NAME) as TOTAL_MB, ROUND(SOFAR / TOTALWORK * 100, 2) || '%' as PERCENT, TIME_REMAINING, ELAPSED_SECONDS, START_TIME, LAST_UPDATE_TIME, MESSAGE, SQL_ID, (select OSUSER from SYS.V$SESSION T4 where T1.SID = T4.SID and T1.SERIAL# = T4.SERIAL#) OSUSER, (select MACHINE from SYS.V$SESSION T4 where T1.SID = T4.SID and T1.SERIAL# = T4.SERIAL#) MACHINE, (select PROGRAM from SYS.V$SESSION T4 where T1.SID = T4.SID and T1.SERIAL# = T4.SERIAL#) PROGRAM, (select ACTION from SYS.V$SESSION T4 where T1.SID = T4.SID and T1.SERIAL# = T4.SERIAL#) ACTION from SYS.V$SESSION_LONGOPS T1 where SOFAR <> TOTALWORK 查询SESSION以及PROCESS select S.INST_ID, S.SID, S.SERIAL#, P.SPID, S.USERNAME, S.PROGRAM from GV$SESSION S join GV$PROCESS P on P.ADDR = S.PADDR and P.INST_ID = S.INST_ID where S.TYPE != 'BACKGROUND'