Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
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
CON_ID NUMBER The ID of the container to which the data pertains. Possible values include:
  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data