Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E25513-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$BACKUP_SPFILE_DETAILS

V$BACKUP_SPFILE_DETAILS displays information about all restorable SP files backed up in the backup set.

Column Datatype Description
SESSION_KEY NUMBER Session identifier
SESSION_RECID NUMBER Session recid
SESSION_STAMP NUMBER Session stamp
BS_KEY NUMBER Unique backup set identifier
SET_STAMP NUMBER Backup set stamp
SET_COUNT NUMBER Backup set count
MODIFICATION_TIME DATE Time the backup set was modified
FILESIZE NUMBER Size, in bytes, of the SPFILE that was backed up
FILESIZE_DISPLAY VARCHAR2(4000) Same value as the FILESIZE column, but converted to a user-displayable format, for example nM, nG, nT, nP, and so on