Monitoring long running operations

Cyrille Modiano

OCP Oracle DBA in Montreal at DBSoft

Latest posts by Cyrille Modiano (see all)

It can be quite useful to be able to monitor long running operations on your database, the view v$session_longops can be used to estimate the time necessary for certain operations to finish.

Monitoring long running operations scripts

Here is a script to monitor a RMAN backup:

Here is a sample result:

Here is a script to monitor the creation of an index:

and the sample result:

 

Leave a Reply