SQL Script Monitor RMAN

Updated: 08-Jan-2002
Version: 1.0

Description

Script displays active RMAN sessions within the database

Parameters

None

SQL Source

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


   select sid, serial#, context,
          round(sofar/DECODE(totalwork,0,sofar,totalwork)*100,2) "% Complete",
          substr(to_char(sysdate,'yymmdd hh24:mi:ss'),1,15) "Time Now",
          elapsed_seconds
   from   v$session_longops
   where  compnam = 'dbms_backup_restore';

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