Oracle RMAN Monitoring Script

Hi,

You can monitor your RMAN session using v$session_longops view.

Here is a script :

SELECT SID,
START_TIME,
TOTALWORK,
SOFAR,
(SOFAR / TOTALWORK) * 100 done,
SYSDATE + TIME_REMAINING / 3600 / 24 EST_END_TIME,
OPNAME
FROM V$SESSION_LONGOPS
WHERE TOTALWORK > SOFAR AND OPNAME LIKE '%backup%' AND OPNAME LIKE 'RMAN%'
/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s