51 lines
1.7 KiB
SQL
51 lines
1.7 KiB
SQL
@@header
|
|
|
|
set term off
|
|
/*
|
|
*
|
|
* Author : Vishal Gupta
|
|
* Purpose : Display Long running operations
|
|
*
|
|
* Revision History:
|
|
* ===================
|
|
* Date Author Description
|
|
* --------- ------------ -----------------------------------------
|
|
* 05-Aug-04 Vishal Gupta First Draft
|
|
*/
|
|
set term on
|
|
|
|
|
|
COLUMN pct_done HEADING "%Done" FORMAT 999 ON
|
|
COLUMN time_remaining HEADING "Remain|(sec)" FORMAT 999,999 ON
|
|
COLUMN elapsed_seconds HEADING "Elapsed|(sec)" FORMAT 999,999 ON
|
|
COLUMN inst_id HEADING "I#" FORMAT 99 ON
|
|
COLUMN sid HEADING "SID" FORMAT 9999 ON
|
|
COLUMN username HEADING "USER" FORMAT a15 ON TRUNCATE
|
|
COLUMN OSUSER HEADING "OSUSER" FORMAT a20 ON TRUNCATE
|
|
COLUMN program HEADING "Program" FORMAT a20 ON TRUNCATE
|
|
COLUMN start_time HEADING "Start Time" FORMAT a18 ON
|
|
COLUMN last_update_time HEADING "Last Update" FORMAT a18 ON
|
|
COLUMN opname HEADING "Operation" FORMAT a20 ON TRUNCATE
|
|
COLUMN target_desc HEADING "Target|Desc" FORMAT a20 ON TRUNCATE
|
|
|
|
SELECT ROUND(l.sofar / l.totalwork *100, 2) pct_done
|
|
, l.time_remaining
|
|
, l.elapsed_seconds
|
|
, s.sid
|
|
, s.inst_id
|
|
, s.username
|
|
, s.osuser
|
|
, s.program
|
|
, TO_CHAR(l.start_time,'DD-MON-YY hh24:mi:ss') start_time
|
|
, TO_CHAR(l.last_update_time,'DD-MON-YY hh24:mi:ss') last_update_Time
|
|
, l.opname
|
|
, l.target_desc
|
|
FROM gv$session_longops l, gv$session s
|
|
WHERE time_remaining > 0
|
|
and s.sid = l.sid
|
|
AND s.inst_id = l.inst_id
|
|
ORDER BY l.elapsed_seconds DESC
|
|
;
|
|
|
|
@@footer
|