|
ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| DAT...
| ENQ...
| INS...
| LOG...
| PGA...
| ROW...
| SES...
| SQL...
| SYS...
GV$DATABASE: Synonym for GV_$DATABASE
iSelfSchooling-SQL> desc GV$DATABASE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
DBID
NUMBER
NAME
VARCHAR2(9)
CREATED
DATE
RESETLOGS_CHANGE#
NUMBER
RESETLOGS_TIME
DATE
PRIOR_RESETLOGS_CHANGE#
NUMBER
PRIOR_RESETLOGS_TIME
DATE
LOG_MODE
VARCHAR2(12)
CHECKPOINT_CHANGE#
NUMBER
ARCHIVE_CHANGE#
NUMBER
CONTROLFILE_TYPE
VARCHAR2(7)
CONTROLFILE_CREATED
DATE
CONTROLFILE_SEQUENCE#
NUMBER
CONTROLFILE_CHANGE#
NUMBER
CONTROLFILE_TIME
DATE
OPEN_RESETLOGS
VARCHAR2(11)
VERSION_TIME
DATE
OPEN_MODE
VARCHAR2(10)
PROTECTION_MODE
VARCHAR2(20)
PROTECTION_LEVEL
VARCHAR2(20)
REMOTE_ARCHIVE
VARCHAR2(8)
ACTIVATION#
NUMBER
SWITCHOVER#
NUMBER
DATABASE_ROLE
VARCHAR2(16)
ARCHIVELOG_CHANGE#
NUMBER
ARCHIVELOG_COMPRESSION
VARCHAR2(8)
SWITCHOVER_STATUS
VARCHAR2(20)
DATAGUARD_BROKER
VARCHAR2(8)
GUARD_STATUS
VARCHAR2(7)
SUPPLEMENTAL_LOG_DATA_MIN
VARCHAR2(8)
SUPPLEMENTAL_LOG_DATA_PK
VARCHAR2(3)
SUPPLEMENTAL_LOG_DATA_UI
VARCHAR2(3)
FORCE_LOGGING
VARCHAR2(3)
PLATFORM_ID
NUMBER
PLATFORM_NAME
VARCHAR2(101)
RECOVERY_TARGET_INCARNATION#
NUMBER
LAST_OPEN_INCARNATION#
NUMBER
CURRENT_SCN
NUMBER
FLASHBACK_ON
VARCHAR2(18)
SUPPLEMENTAL_LOG_DATA_FK
VARCHAR2(3)
SUPPLEMENTAL_LOG_DATA_ALL
VARCHAR2(3)
DB_UNIQUE_NAME
VARCHAR2(30)
STANDBY_BECAME_PRIMARY_SCN NUMBER
FS_FAILOVER_STATUS
VARCHAR2(21)
FS_FAILOVER_CURRENT_TARGET VARCHAR2(30)
FS_FAILOVER_THRESHOLD
NUMBER
FS_FAILOVER_OBSERVER_PRESENT VARCHAR2(7)
FS_FAILOVER_OBSERVER_HOST
VARCHAR2(512)
GV$DATABASE_BLOCK_CORRUPTION:
Synonym
for GV_$DATABASE_BLOCK_CORRUPTION
iSelfSchooling-SQL> desc GV$DATABASE_BLOCK_CORRUPTION;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
FILE#
NUMBER
BLOCK#
NUMBER
BLOCKS
NUMBER
CORRUPTION_CHANGE#
NUMBER
CORRUPTION_TYPE
VARCHAR2(9)
GV$DATABASE_INCARNATION: Synonym for GV_$DATABASE_INCARNATION
iSelfSchooling-SQL> desc GV$DATABASE_INCARNATION;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
INCARNATION#
NUMBER
RESETLOGS_CHANGE#
NUMBER
RESETLOGS_TIME
DATE
PRIOR_RESETLOGS_CHANGE#
NUMBER
PRIOR_RESETLOGS_TIME
DATE
STATUS
VARCHAR2(7)
RESETLOGS_ID
NUMBER
PRIOR_INCARNATION#
NUMBER
FLASHBACK_DATABASE_ALLOWED
VARCHAR2(26)
GV$DATAFILE: Synonym for GV_$DATAFILE
iSelfSchooling-SQL> desc GV$DATAFILE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
FILE#
NUMBER
CREATION_CHANGE#
NUMBER
CREATION_TIME
DATE
TS#
NUMBER
RFILE#
NUMBER
STATUS
VARCHAR2(7)
ENABLED
VARCHAR2(10)
CHECKPOINT_CHANGE#
NUMBER
CHECKPOINT_TIME
DATE
UNRECOVERABLE_CHANGE#
NUMBER
UNRECOVERABLE_TIME
DATE
LAST_CHANGE#
NUMBER
LAST_TIME
DATE
OFFLINE_CHANGE#
NUMBER
ONLINE_CHANGE#
NUMBER
ONLINE_TIME
DATE
BYTES
NUMBER
BLOCKS
NUMBER
CREATE_BYTES
NUMBER
BLOCK_SIZE
NUMBER
NAME
VARCHAR2(513)
PLUGGED_IN
NUMBER
BLOCK1_OFFSET
NUMBER
AUX_NAME
VARCHAR2(513)
FIRST_NONLOGGED_SCN
NUMBER
FIRST_NONLOGGED_TIME
DATE
GV$DATAFILE_COPY: Synonym for GV_$DATAFILE_COPY
iSelfSchooling-SQL> desc GV$DATAFILE_COPY;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
RECID
NUMBER
STAMP
NUMBER
NAME
VARCHAR2(513)
TAG
VARCHAR2(32)
FILE#
NUMBER
RFILE#
NUMBER
CREATION_CHANGE#
NUMBER
CREATION_TIME
DATE
RESETLOGS_CHANGE#
NUMBER
RESETLOGS_TIME
DATE
INCREMENTAL_LEVEL
NUMBER
CHECKPOINT_CHANGE#
NUMBER
CHECKPOINT_TIME
DATE
ABSOLUTE_FUZZY_CHANGE#
NUMBER
RECOVERY_FUZZY_CHANGE#
NUMBER
RECOVERY_FUZZY_TIME
DATE
ONLINE_FUZZY
VARCHAR2(3)
BACKUP_FUZZY
VARCHAR2(3)
MARKED_CORRUPT
NUMBER
MEDIA_CORRUPT
NUMBER
LOGICALLY_CORRUPT
NUMBER
BLOCKS
NUMBER
BLOCK_SIZE
NUMBER
OLDEST_OFFLINE_RANGE
NUMBER
DELETED
VARCHAR2(3)
STATUS
VARCHAR2(1)
COMPLETION_TIME
DATE
CONTROLFILE_TYPE VARCHAR2(1)
KEEP
VARCHAR2(3)
KEEP_UNTIL
DATE
KEEP_OPTIONS
VARCHAR2(10)
SCANNED
VARCHAR2(3)
IS_RECOVERY_DEST_FILE
VARCHAR2(3)
RMAN_STATUS_RECID
NUMBER
RMAN_STATUS_STAMP
NUMBER
GV$DATAFILE_HEADER: Synonym for GV_$DATAFILE_HEADER
iSelfSchooling-SQL> desc GV$DATAFILE_HEADER;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
FILE#
NUMBER
STATUS
VARCHAR2(7)
ERROR
VARCHAR2(18)
FORMAT
NUMBER
RECOVER
VARCHAR2(3)
FUZZY
VARCHAR2(3)
CREATION_CHANGE#
NUMBER
CREATION_TIME
DATE
TABLESPACE_NAME
VARCHAR2(30)
TS#
NUMBER
RFILE#
NUMBER
RESETLOGS_CHANGE#
NUMBER
RESETLOGS_TIME
DATE
CHECKPOINT_CHANGE#
NUMBER
CHECKPOINT_TIME
DATE
CHECKPOINT_COUNT
NUMBER
BYTES
NUMBER
BLOCKS
NUMBER
NAME
VARCHAR2(513)
SPACE_HEADER
VARCHAR2(40)
LAST_DEALLOC_SCN
VARCHAR2(16)
GV$DATAGUARD_CONFIG: Synonym for GV_$DATAGUARD_CONFIG
iSelfSchooling-SQL> desc GV$DATAGUARD_CONFIG;
Name
Null?
Type
----------------------------- -------- --------------------
DB_UNIQUE_NAME
VARCHAR2(30)
GV$DATAGUARD_STATUS: Synonym for GV_$DATAGUARD_STATUS
iSelfSchooling-SQL> desc GV$DATAGUARD_STATUS;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
FACILITY
VARCHAR2(24)
SEVERITY
VARCHAR2(13)
DEST_ID
NUMBER
MESSAGE_NUM
NUMBER
ERROR_CODE
NUMBER
CALLOUT
VARCHAR2(3)
TIMESTAMP
DATE
|