Databases Reference
In-Depth Information
The prior output indicates that the RMAN backups took a little longer on August 10 (number 1 rank), but nothing
really out of the ordinary.
Refer to Table 16-1 for the view that you should inspect if you need to analyze backup performance information
on a more granular basis than what's available in V$RMAN_BACKUP_JOB_DETAILS. The view names in Table 16-1
are somewhat descriptive of each view's content. For example, if you want to analyze what is happening at the backup
set level, then V$BACKUP_SET or V$BACKUP_SET_DETAILS will provide information at that level. The recovery
catalog (RC) views are available only in your recovery catalog database. The RC views can be more valuable to you in
that they are capable of providing a longer history of information than the V$ views.
Table 16-1. Description of Detailed Performance Views
View Name
Recovery Catalog View
V$RMAN_BACKUP_SUBJOB_DETAILS
RC_RMAN_BACKUP_SUBJOB_DETAILS
V$BACKUP_SET
RC_BACKUP_SET
V$BACKUP_SET_DETAILS
RC_BACKUP_SET_DETAILS
V$BACKUP_SET_SUMMARY
RC_BACKUP_SET_SUMMARY
V$BACKUP_PIECE
RC_BACKUP_PIECE
V$BACKUP_PIECE_DETAILS
RC_BACKUP_PIECE_DETAILS
V$BACKUP_DATAFILE
RC_BACKUP_DATAFILE
V$BACKUP_DATAFILE_DETAILS
RC_BACKUP_DATAFILE_DETAILS
V$BACKUP_DATAFILE_SUMMARY
RC_BACKUP_DATAFILE_SUMMARY
V$BACKUP_FILES
RC_BACKUP_FILES
V$BACKUP_COPY_DETAILS
RC_BACKUP_COPY_DETAILS
V$BACKUP_COPY_SUMMARY
RC_BACKUP_COPY_SUMMARY
V$BACKUP_REDOLOG
RC_BACKUP_REDOLOG
V$BACKUP_ARCHIVELOG_DETAILS
RC_BACKUP_ARCHIVELOG_DETAILS
V$BACKUP_ARCHIVELOG_SUMMARY
RC_BACKUP_ARCHIVELOG_SUMMARY
V$BACKUP_CONTROLFILE_DETAILS
RC_BACKUP_CONTROLFILE_DETAILS
V$BACKUP_CONTROLFILE_SUMMARY
RC_BACKUP_CONTROLFILE_SUMMARY
V$BACKUP_SPFILE
RC_BACKUP_SPFILE
V$BACKUP_SPFILE_DETAILS
RC_BACKUP_SPFILE_DETAILS
V$BACKUP_SPFILE_SUMMARY
RC_BACKUP_SPFILE_SUMMARY
 
 
Search WWH ::




Custom Search