작업 진행율

-- ACtive Process view
SELECT  s.SQL_HASH_VALUE,s.SADDR, s.SID, s.SERIAL#, s.AUDSID, s.PADDR, s.USER#, s.USERNAME, s.COMMAND, s.OWNERID, s.TADDR, s.LOCKWAIT, s.STATUS,
s.SERVER, s.SCHEMA#, s.SCHEMANAME, s.OSUSER, s.PROCESS, s.MACHINE, s.TERMINAL, UPPER(s.PROGRAM) PROGRAM, s.TYPE, s.SQL_ADDRESS,
s.PREV_SQL_ADDR, s.PREV_HASH_VALUE, s.MODULE, s.MODULE_HASH, s.ACTION, s.ACTION_HASH, s.CLIENT_INFO,
s.FIXED_TABLE_SEQUENCE, s.ROW_WAIT_OBJ#, s.ROW_WAIT_FILE#, s.ROW_WAIT_BLOCK#, s.ROW_WAIT_ROW#, s.LOGON_TIME, s.LAST_CALL_ET,
s.PDML_ENABLED, s.FAILOVER_TYPE, s.FAILOVER_METHOD, s.FAILED_OVER, s.RESOURCE_CONSUMER_GROUP, s.PDML_STATUS, s.PDDL_STATUS,
s.PQ_STATUS, s.CURRENT_QUEUE_DURATION, s.CLIENT_IDENTIFIER, p.program  "OSProgram", p.spid, p.pid
FROM V$SESSION s, V$PROCESS p
 WHERE  ( (s.USERNAME is not null)
 and (NVL(s.osuser,'x') <> 'SYSTEM')
 and (s.type <> 'BACKGROUND') )
 and  p.addr(+)=s.paddr
 and  status = 'ACTIVE'
order by "STATUS", OWNERID

-- Current SQL
SELECT SQL_TEXT
FROM  V$SQLTEXT_WITH_NEWLINES
WHERE HASH_VALUE=TO_NUMBER(3303688599    )
ORDER BY PIECE
;

-- LongOPs
select username,sid, serial#
,sofar,totalwork
,trunc(sofar / totalwork,3) * 100 percent
,time_remaining, elapsed_seconds
,opname,target,message
from v$session_longops
where (sid,serial#) in
      (
        select sid,serial#
        from v$session_longops
        where time_remaining <> 0
      )
order by sid, serial#, start_time