V$ Dynamic Views

Audit RMAN Backup Job History with V$RMAN_BACKUP_JOB_DETAILS Purpose V$RMAN_BACKUP_JOB_DETAILS is the one dynamic view built specifically at the job level rather than the piece or file level. Where other RMAN views report on individual datafile backups or individual backup set pieces, this view collapses an entire …

Watch Long-Running SQL in Real Time with V$SQL_MONITOR Purpose An AWR report describes what happened over the last hour. A SQL trace file describes what happened after the statement has already finished writing it. V$SQL_MONITOR answers a different question: what is running right now, and how far along is it. …