SQL Script Monitor Long Operations

Updated: 03-Jan-2003
Version: 1.0

Description

Queries the session details for long running operations such as a Full Table /Index Scans, RMAN and Analyze Tables using DBMS_STATS

Parameters

None.

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

set pages 200

col sid form 99
col units form a7
col username form a8
col opname form a20
col target form a15
col start_time form a12 heading "Start Time"
col progress form 999 heading "%"
col elapsed_seconds form 999900 heading "Secs"

alter session set nls_date_format='DD-MON HH24:MI';

spool longops.lst

select sid
      , username
      , opname
      , decode(totalwork,0,0,null,0,sofar*100/totalwork) progress
      , totalwork
      , units
      , start_time
      , elapsed_seconds
from v$session_longops
order by sid, start_time
/

spool off

Related Links

Oracle 10g: (SQL Script) Monitor RMAN

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links