|
ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| DAT...
| ENQ...
| INS...
| LOG...
| PGA...
| ROW...
| SES...
| SQL...
| SYS...
GV$BACKUP_ASYNC_IO: Synonym for GV_$BACKUP_ASYNC_IO
iSelfSchooling-SQL> desc GV$BACKUP_ASYNC_IO;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$BACKUP_CORRUPTION: Synonym for GV_$BACKUP_CORRUPTION
iSelfSchooling-SQL> desc GV$BACKUP_CORRUPTION;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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)
GV$BACKUP_DATAFILE: Synonym for GV_$BACKUP_DATAFILE
iSelfSchooling-SQL> desc GV$BACKUP_DATAFILE;
Name Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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)
GV$BACKUP_DEVICE: Synonym for GV_$BACKUP_DEVICE
iSelfSchooling-SQL> desc GV$BACKUP_DEVICE;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
DEVICE_TYPE
VARCHAR2(17)
DEVICE_NAME
VARCHAR2(513)
GV$BACKUP_PIECE: Synonym for GV_$BACKUP_PIECE
iSelfSchooling-SQL> desc GV$BACKUP_PIECE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
RECID
NUMBER
STAMP
NUMBER
SET_STAMP
NUMBER
SET_COUNT
NUMBER
PIECE#
NUMBER
COPY#
NUMBER
DEVICE_TYPE
VARCHAR2(17)
HANDLE
VARCHAR2(513)
COMMENTS
VARCHAR2(64)
MEDIA
VARCHAR2(65)
MEDIA_POOL
NUMBER
CONCUR
VARCHAR2(3)
TAG
VARCHAR2(32)
STATUS
VARCHAR2(1)
DELETED
VARCHAR2(3)
START_TIME
DATE
COMPLETION_TIME
DATE
ELAPSED_SECONDS
NUMBER
BYTES
NUMBER
IS_RECOVERY_DEST_FILE
VARCHAR2(3)
RMAN_STATUS_RECID
NUMBER
RMAN_STATUS_STAMP
NUMBER
COMPRESSED
VARCHAR2(3)
GV$BACKUP_REDOLOG: Synonym for GV_$BACKUP_REDOLOG
iSelfSchooling-SQL> desc GV$BACKUP_REDOLOG;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
RECID
NUMBER
STAMP
NUMBER
SET_STAMP
NUMBER
SET_COUNT
NUMBER
THREAD#
NUMBER
SEQUENCE#
NUMBER
RESETLOGS_CHANGE#
NUMBER
RESETLOGS_TIME
DATE
FIRST_CHANGE#
NUMBER
FIRST_TIME
DATE
NEXT_CHANGE#
NUMBER
NEXT_TIME
DATE
BLOCKS
NUMBER
BLOCK_SIZE
NUMBER
GV$BACKUP_SET: Synonym for GV_$BACKUP_SET
iSelfSchooling-SQL> desc GV$BACKUP_SET;
Name Null?
Type
----------------------------- -------- --------------------
INST_ID
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
INPUT_FILE_SCAN_ONLY
VARCHAR2(3)
KEEP
VARCHAR2(3)
KEEP_UNTIL
DATE
KEEP_OPTIONS
VARCHAR2(10)
GV$BACKUP_SPFILE: Synonym for GV_$BACKUP_SPFILE
iSelfSchooling-SQL> desc GV$BACKUP_SPFILE;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
RECID
NUMBER
STAMP
NUMBER
SET_STAMP
NUMBER
SET_COUNT
NUMBER
MODIFICATION_TIME
DATE
BYTES
NUMBER
COMPLETION_TIME
DATE
GV$BACKUP_SYNC_IO: Synonym for GV_$BACKUP_SYNC_IO
iSelfSchooling-SQL> desc GV$BACKUP_SYNC_IO;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
|