|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| BUF...
| DEL...
| FLA...
| LOG...
| MTT...
| PX...
| SEG...
| SOR...
| SQL...
| TEM...
V$BACKUP_ASYNC_IO: Synonym for V_$BACKUP_ASYNC_IO
iSelfSchooling-SQL> desc V$BACKUP_ASYNC_IO;
Name
Null? Type
----------------------------- -------- --------------------
SID
NUMBER
SERIAL
NUMBER
USE_COUNT
NUMBER
RMAN_STATUS_RECID
NUMBER
RMAN_STATUS_STAMP
NUMBER
DEVICE_TYPE
VARCHAR2(17)
TYPE
VARCHAR2(9)
STATUS
VARCHAR2(11)
FILENAME
VARCHAR2(513)
SET_COUNT
NUMBER
SET_STAMP
NUMBER
BUFFER_SIZE
NUMBER
BUFFER_COUNT
NUMBER
TOTAL_BYTES
NUMBER
OPEN_TIME
DATE
CLOSE_TIME
DATE
ELAPSED_TIME
NUMBER
MAXOPENFILES
NUMBER
BYTES
NUMBER
EFFECTIVE_BYTES_PER_SECOND NUMBER
IO_COUNT
NUMBER
READY
NUMBER
SHORT_WAITS
NUMBER
SHORT_WAIT_TIME_TOTAL
NUMBER
SHORT_WAIT_TIME_MAX
NUMBER
LONG_WAITS
NUMBER
LONG_WAIT_TIME_TOTAL
NUMBER
LONG_WAIT_TIME_MAX
NUMBER
V$BACKUP_CONTROLFILE_DETAILS: Synonym for
V_$BACKUP_CONTROLFILE_DETAILS
iSelfSchooling-SQL> desc V$BACKUP_CONTROLFILE_DETAILS;
Name
Null? Type
----------------------------- -------- --------------------
BTYPE
CHAR(9)
BTYPE_KEY
NUMBER
SESSION_KEY
NUMBER
SESSION_RECID
NUMBER
SESSION_STAMP
NUMBER
ID1
NUMBER
ID2
NUMBER
CREATION_TIME
DATE
RESETLOGS_CHANGE#
NUMBER
RESETLOGS_TIME
DATE
CHECKPOINT_CHANGE#
NUMBER
CHECKPOINT_TIME
DATE
FILESIZE
NUMBER
COMPRESSION_RATIO
NUMBER
FILESIZE_DISPLAY
VARCHAR2(4000)
V$BACKUP_CONTROLFILE_SUMMARY: Synonym for
V_$BACKUP_CONTROLFILE_SUMMARY
iSelfSchooling-SQL> desc V$BACKUP_CONTROLFILE_SUMMARY;
Name
Null? Type
----------------------------- -------- --------------------
NUM_FILES_BACKED
NUMBER
NUM_DISTINCT_FILES_BACKED
NUMBER
MIN_CHECKPOINT_CHANGE#
NUMBER
MAX_CHECKPOINT_CHANGE#
NUMBER
MIN_CHECKPOINT_TIME
DATE
MAX_CHECKPOINT_TIME
DATE
INPUT_BYTES
NUMBER
OUTPUT_BYTES
NUMBER
COMPRESSION_RATIO
NUMBER
INPUT_BYTES_DISPLAY
VARCHAR2(4000)
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
V$BACKUP_COPY_DETAILS: Synonym for V_$BACKUP_COPY_DETAILS
iSelfSchooling-SQL> desc V$BACKUP_COPY_DETAILS;
Name
Null? Type
----------------------------- -------- --------------------
SESSION_KEY
NUMBER
SESSION_RECID
NUMBER
SESSION_STAMP
NUMBER
COPY_KEY
NUMBER
FILE#
NUMBER
NAME
VARCHAR2(513)
TAG
VARCHAR2(32)
CREATION_CHANGE#
NUMBER
CREATION_TIME
DATE
CHECKPOINT_CHANGE#
NUMBER
CHECKPOINT_TIME
DATE
MARKED_CORRUPT
NUMBER
OUTPUT_BYTES
NUMBER
COMPLETION_TIME
DATE
CONTROLFILE_TYPE
VARCHAR2(1)
KEEP
VARCHAR2(3)
KEEP_UNTIL
DATE
KEEP_OPTIONS
VARCHAR2(10)
IS_RECOVERY_DEST_FILE
VARCHAR2(3)
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
V$BACKUP_COPY_SUMMARY: Synonym for V_$BACKUP_COPY_SUMMARY
iSelfSchooling-SQL> desc V$BACKUP_COPY_SUMMARY;
Name
Null?
Type
----------------------------- -------- --------------------
NUM_COPIES
NUMBER
NUM_DISTINCT_COPIES
NUMBER
MIN_CHECKPOINT_CHANGE#
NUMBER
MAX_CHECKPOINT_CHANGE#
NUMBER
MIN_CHECKPOINT_TIME
DATE
MAX_CHECKPOINT_TIME
DATE
OUTPUT_BYTES
NUMBER
OUTPUT_BYTES_DISPLAY
VARCHAR2(4000)
V$BACKUP_CORRUPTION: Synonym for V_$BACKUP_CORRUPTION
iSelfSchooling-SQL> desc V$BACKUP_CORRUPTION;
Name
Null? Type
----------------------------- -------- --------------------
RECID
NUMBER
STAMP
NUMBER
SET_STAMP
NUMBER
SET_COUNT
NUMBER
PIECE#
NUMBER
FILE#
NUMBER
BLOCK#
NUMBER
BLOCKS
NUMBER
CORRUPTION_CHANGE#
NUMBER
MARKED_CORRUPT
VARCHAR2(3)
CORRUPTION_TYPE
VARCHAR2(9)
V$BACKUP_DATAFILE: Synonym for V_$BACKUP_DATAFILE
iSelfSchooling-SQL> desc V$BACKUP_DATAFILE;
Name
Null? Type
----------------------------- -------- --------------------
RECID
NUMBER
STAMP
NUMBER
SET_STAMP
NUMBER
SET_COUNT
NUMBER
FILE#
NUMBER
CREATION_CHANGE#
NUMBER
CREATION_TIME
DATE
RESETLOGS_CHANGE#
NUMBER
RESETLOGS_TIME
DATE
INCREMENTAL_LEVEL
NUMBER
INCREMENTAL_CHANGE#
NUMBER
CHECKPOINT_CHANGE#
NUMBER
CHECKPOINT_TIME
DATE
ABSOLUTE_FUZZY_CHANGE#
NUMBER
MARKED_CORRUPT
NUMBER
MEDIA_CORRUPT
NUMBER
LOGICALLY_CORRUPT
NUMBER
DATAFILE_BLOCKS
NUMBER
BLOCKS
NUMBER
BLOCK_SIZE
NUMBER
OLDEST_OFFLINE_RANGE
NUMBER
COMPLETION_TIME
DATE
CONTROLFILE_TYPE
VARCHAR2(1)
USED_CHANGE_TRACKING
VARCHAR2(3)
BLOCKS_READ
NUMBER
USED_OPTIMIZATION
VARCHAR2(3)
V$BACKUP_DATAFILE_DETAILS: Synonym for V_$BACKUP_DATAFILE_DETAILS
iSelfSchooling-SQL> desc V$BACKUP_DATAFILE_DETAILS;
Name
Null? Type
----------------------------- -------- --------------------
BTYPE
CHAR(9)
BTYPE_KEY
NUMBER
SESSION_KEY
NUMBER
SESSION_RECID
NUMBER
SESSION_STAMP
NUMBER
ID1
NUMBER
ID2
NUMBER
FILE#
NUMBER
CREATION_CHANGE#
NUMBER
CREATION_TIME
DATE
RESETLOGS_CHANGE#
NUMBER
RESETLOGS_TIME
DATE
INCREMENTAL_LEVEL
NUMBER
INCREMENTAL_CHANGE#
NUMBER
CHECKPOINT_CHANGE#
NUMBER
CHECKPOINT_TIME
DATE
MARKED_CORRUPT
NUMBER
FILESIZE
NUMBER
COMPRESSION_RATIO
NUMBER
TS#
NUMBER
TSNAME
VARCHAR2(30)
FILESIZE_DISPLAY
VARCHAR2(4000)
V$BACKUP_DATAFILE_SUMMARY: Synonym for V_$BACKUP_DATAFILE_SUMMARY
iSelfSchooling-SQL> desc V$BACKUP_DATAFILE_SUMMARY;
Name
Null? Type
----------------------------- -------- --------------------
NUM_FILES_BACKED & |