Logo

SQL Script

Monitor RMAN

 Tested on Oracle 8.1 Tested on Oracle 8.0

Updated : 08-Jan-2002
Version : 1.0

Description

Script displays active RMAN sessions within the database

Parameters

None.

SQL Source

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  substr(opname,1,4)='RMAN';       --> for 8.1;
/* where  compnam = 'dbms_backup_restore'; --> for 8.0 */

Return to Index of SQL Scripts

Home | Company Profile | Services | Contact Us | SQL scripts and tips | Quiz
Legal

Logo