27 lines
979 B
SQL
27 lines
979 B
SQL
-- -----------------------------------------------------------------------------------
|
|
-- File Name : https://oracle-base.com/dba/monitoring/longops.sql
|
|
-- Author : Tim Hall
|
|
-- Description : Displays information on all long operations.
|
|
-- Requirements : Access to the V$ views.
|
|
-- Call Syntax : @longops
|
|
-- Last Modified: 03/07/2003
|
|
-- -----------------------------------------------------------------------------------
|
|
|
|
COLUMN sid FORMAT 999
|
|
COLUMN serial# FORMAT 9999999
|
|
COLUMN machine FORMAT A30
|
|
COLUMN progress_pct FORMAT 99999999.00
|
|
COLUMN elapsed FORMAT A10
|
|
COLUMN remaining FORMAT A10
|
|
|
|
SELECT s.sid,
|
|
s.serial#,
|
|
s.machine,
|
|
ROUND(sl.elapsed_seconds/60) || ':' || MOD(sl.elapsed_seconds,60) elapsed,
|
|
ROUND(sl.time_remaining/60) || ':' || MOD(sl.time_remaining,60) remaining,
|
|
ROUND(sl.sofar/sl.totalwork*100, 2) progress_pct
|
|
FROM v$session s,
|
|
v$session_longops sl
|
|
WHERE s.sid = sl.sid
|
|
AND s.serial# = sl.serial#;
|