[Home] [Help] [Dependency Information]
Object Name: | V_$BACKUP_SET_DETAILS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_KEY | NUMBER | |||
SESSION_RECID | NUMBER | |||
SESSION_STAMP | NUMBER | |||
BS_KEY | NUMBER | |||
RECID | NUMBER | |||
STAMP | NUMBER | |||
SET_STAMP | NUMBER | |||
SET_COUNT | NUMBER | |||
BACKUP_TYPE | VARCHAR2 | (1) | ||
CONTROLFILE_INCLUDED | VARCHAR2 | (3) | ||
INCREMENTAL_LEVEL | NUMBER | |||
PIECES | NUMBER | |||
START_TIME | DATE | |||
COMPLETION_TIME | DATE | |||
ELAPSED_SECONDS | NUMBER | |||
BLOCK_SIZE | NUMBER | |||
KEEP | VARCHAR2 | (3) | ||
KEEP_UNTIL | DATE | |||
KEEP_OPTIONS | VARCHAR2 | (11) | ||
DEVICE_TYPE | VARCHAR2 | (17) | ||
COMPRESSED | VARCHAR2 | (3) | ||
NUM_COPIES | NUMBER | |||
OUTPUT_BYTES | NUMBER | |||
ORIGINAL_INPUT_BYTES | NUMBER | |||
COMPRESSION_RATIO | NUMBER | |||
STATUS | CHAR | (1) | ||
ORIGINAL_INPRATE_BYTES | NUMBER | |||
OUTPUT_RATE_BYTES | NUMBER | |||
ORIGINAL_INPUT_BYTES_DISPLAY | VARCHAR2 | (4000) | ||
OUTPUT_BYTES_DISPLAY | VARCHAR2 | (4000) | ||
ORIGINAL_INPRATE_BYTES_DISPLAY | VARCHAR2 | (4000) | ||
OUTPUT_RATE_BYTES_DISPLAY | VARCHAR2 | (4000) | ||
TIME_TAKEN_DISPLAY | VARCHAR2 | (4000) | ||
ENCRYPTED | VARCHAR2 | (3) | ||
BACKED_BY_OSB | VARCHAR2 | (3) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_KEY
, SESSION_RECID
, SESSION_STAMP
, BS_KEY
, RECID
, STAMP
, SET_STAMP
, SET_COUNT
, BACKUP_TYPE
, CONTROLFILE_INCLUDED
, INCREMENTAL_LEVEL
, PIECES
, START_TIME
, COMPLETION_TIME
, ELAPSED_SECONDS
, BLOCK_SIZE
, KEEP
, KEEP_UNTIL
, KEEP_OPTIONS
, DEVICE_TYPE
, COMPRESSED
, NUM_COPIES
, OUTPUT_BYTES
, ORIGINAL_INPUT_BYTES
, COMPRESSION_RATIO
, STATUS
, ORIGINAL_INPRATE_BYTES
, OUTPUT_RATE_BYTES
, ORIGINAL_INPUT_BYTES_DISPLAY
, OUTPUT_BYTES_DISPLAY
, ORIGINAL_INPRATE_BYTES_DISPLAY
, OUTPUT_RATE_BYTES_DISPLAY
, TIME_TAKEN_DISPLAY
, ENCRYPTED
, BACKED_BY_OSB
, CON_ID
FROM SYS.V_$BACKUP_SET_DETAILS;
|
|
|