Thursday, December 17, 2009

V$BACKUP_SET_SUMMARY

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

I have stopped updating the blog.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.


===============================================================

V$BACKUP_SET_SUMMARY provides summary information for a backup set.
Column
Datatype
Description
NUM_BACKUPSETS
NUMBER
Total number of backup sets created
OLDEST_BACKUP_TIME
DATE
Oldest backup start time
NEWEST_BACKUP_TIME
DATE
Newest backup start time
OUTPUT_BYTES
NUMBER
Number of output bytes (not including multiple copies)
ORIGINAL_INPUT_BYTES
NUMBER
Number of input bytes when backup sets were created
ORIGINAL_INPRATE_BYTES
NUMBER
Average input rate
OUTPUT_RATE_BYTES
NUMBER
Average output rate
COMPRESSION_RATIO
NUMBER
Compression ratio
ORIGINAL_INPUT_BYTES_DISPLAY
VARCHAR2(4000)
Displayable format for input bytes
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
Displayable format for output bytes
ORIGINAL_INPRATE_BYTES_DISPLAY
VARCHAR2(4000)
Displayable format for input rate
OUTPUT_RATE_BYTES_DISPLAY
VARCHAR2(4000)
Displayable format for output rate

Note:

1.       The corresponding RMAN catalog view is RC_BACKUP_SET_SUMMARY.


Oracle data dictionary views

Last updated: 2009-12-15 Tuesday


No comments:

Post a Comment