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
CLOSE_TIME
DATE
ELAPSED_TIME
NUMBER
MAXOPENFILES
NUMBER
BYTES
NUMBER
EFFECTIVE_BYTES_PER_SECOND NUMBER
IO_COUNT
NUMBER
IO_TIME_TOTAL
NUMBER
IO_TIME_MAX
NUMBER
DISCRETE_BYTES_PER_SECOND
NUMBER
GV$BGPROCESS: Synonym for GV_$BGPROCESS
iSelfSchooling-SQL> desc GV$BGPROCESS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
PADDR
RAW(8)
PSERIAL#
NUMBER
NAME
VARCHAR2(5)
DESCRIPTION
VARCHAR2(64)
ERROR
NUMBER
GV$BH: Synonym for GV_$BH
iSelfSchooling-SQL> desc GV$BH;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
FILE#
NUMBER
BLOCK#
NUMBER
CLASS#
NUMBER
STATUS
VARCHAR2(7)
XNC
NUMBER
FORCED_READS
NUMBER
FORCED_WRITES
NUMBER
LOCK_ELEMENT_ADDR
RAW(8)
LOCK_ELEMENT_NAME
NUMBER
LOCK_ELEMENT_CLASS
NUMBER
DIRTY
VARCHAR2(1)
TEMP
VARCHAR2(1)
PING
VARCHAR2(1)
STALE
VARCHAR2(1)
DIRECT
VARCHAR2(1)
NEW
CHAR(1)
OBJD
NUMBER
TS#
NUMBER
GV$BLOCKING_QUIESCE: Synonym for GV_$BLOCKING_QUIESCE
iSelfSchooling-SQL> desc GV$BLOCKING_QUIESCE;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
SID
NUMBER
GV$BSP: Synonym for GV_$BSP
iSelfSchooling-SQL> desc GV$BSP;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
CR_REQUESTS
NUMBER
CURRENT_REQUESTS
NUMBER
DATA_REQUESTS
NUMBER
UNDO_REQUESTS
NUMBER
TX_REQUESTS
NUMBER
CURRENT_RESULTS
NUMBER
PRIVATE_RESULTS
NUMBER
ZERO_RESULTS
NUMBER
DISK_READ_RESULTS
NUMBER
FAIL_RESULTS
NUMBER
FAIRNESS_DOWN_CONVERTS
NUMBER
FAIRNESS_CLEARS
NUMBER
FREE_LOCK_ELEMENTS
NUMBER
FLUSHES
NUMBER
FLUSHES_QUEUED
NUMBER
FLUSH_QUEUE_FULL
NUMBER
FLUSH_MAX_TIME
NUMBER
LIGHT_WORKS
NUMBER
ERRORS
NUMBER
GV$BUFFERED_PUBLISHERS: Synonym for GV_$BUFFERED_PUBLISHERS
iSelfSchooling-SQL> desc GV$BUFFERED_PUBLISHERS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
QUEUE_ID
NUMBER
QUEUE_SCHEMA
VARCHAR2(30)
QUEUE_NAME
VARCHAR2(30)
SENDER_NAME
VARCHAR2(30)
SENDER_ADDRESS
VARCHAR2(1024)
SENDER_PROTOCOL
NUMBER
NUM_MSGS
NUMBER
CNUM_MSGS
NUMBER
LAST_ENQUEUED_MSG
NUMBER
UNBROWSED_MSGS
NUMBER
OVERSPILLED_MSGS
NUMBER
MEMORY_USAGE
NUMBER
PUBLISHER_STATE
VARCHAR2(59)
GV$BUFFERED_QUEUES: Synonym for GV_$BUFFERED_QUEUES
iSelfSchooling-SQL> desc GV$BUFFERED_QUEUES;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
QUEUE_ID
NUMBER
QUEUE_SCHEMA
VARCHAR2(30)
QUEUE_NAME
VARCHAR2(30)
STARTUP_TIME
DATE
NUM_MSGS
NUMBER
SPILL_MSGS
NUMBER
CNUM_MSGS
NUMBER
CSPILL_MSGS
NUMBER
EXPIRED_MSGS
NUMBER
GV$BUFFERED_SUBSCRIBERS: Synonym for GV_$BUFFERED_SUBSCRIBERS
iSelfSchooling-SQL> desc GV$BUFFERED_SUBSCRIBERS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
QUEUE_ID
NUMBER
QUEUE_SCHEMA
VARCHAR2(30)
QUEUE_NAME
VARCHAR2(30)
SUBSCRIBER_ID
NUMBER
SUBSCRIBER_NAME
VARCHAR2(30)
SUBSCRIBER_ADDRESS
VARCHAR2(1024)
PROTOCOL
NUMBER
SUBSCRIBER_TYPE
VARCHAR2(30)
STARTUP_TIME
DATE
LAST_BROWSED_SEQ
NUMBER
LAST_BROWSED_NUM
NUMBER
LAST_DEQUEUED_SEQ
NUMBER
LAST_DEQUEUED_NUM
NUMBER
CURRENT_ENQ_SEQ
NUMBER
NUM_MSGS
NUMBER
CNUM_MSGS
NUMBER
TOTAL_DEQUEUED_MSG
NUMBER
TOTAL_SPILLED_MSG
NUMBER
EXPIRED_MSGS
NUMBER
GV$BUFFER_POOL: Synonym for GV_$BUFFER_POOL
iSelfSchooling-SQL> desc GV$BUFFER_POOL;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ID
NUMBER
NAME
VARCHAR2(20)
BLOCK_SIZE
NUMBER
RESIZE_STATE
VARCHAR2(10)
CURRENT_SIZE
NUMBER
BUFFERS
NUMBER
TARGET_SIZE
NUMBER
TARGET_BUFFERS
NUMBER
PREV_SIZE
NUMBER
PREV_BUFFERS
NUMBER
LO_BNUM
NUMBER
HI_BNUM
NUMBER
LO_SETID
NUMBER
HI_SETID
NUMBER
SET_COUNT
NUMBER
GV$BUFFER_POOL_STATISTICS: Synonym for GV_$BUFFER_POOL_STATISTICS
iSelfSchooling-SQL> desc GV$BUFFER_POOL_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ID
NUMBER
NAME
VARCHAR2(20)
BLOCK_SIZE
NUMBER
SET_MSIZE
NUMBER
CNUM_REPL
NUMBER
CNUM_WRITE
NUMBER
CNUM_SET
NUMBER
BUF_GOT
NUMBER
SUM_WRITE
NUMBER
SUM_SCAN
NUMBER
FREE_BUFFER_WAIT
NUMBER
WRITE_COMPLETE_WAIT
NUMBER
BUFFER_BUSY_WAIT
NUMBER
FREE_BUFFER_INSPECTED
NUMBER
DIRTY_BUFFERS_INSPECTED
NUMBER
DB_BLOCK_CHANGE
NUMBER
DB_BLOCK_GETS
NUMBER
CONSISTENT_GETS
NUMBER
PHYSICAL_READS
NUMBER
PHYSICAL_WRITES
NUMBER
GV$CIRCUIT: Synonym for GV_$CIRCUIT
iSelfSchooling-SQL> desc GV$CIRCUIT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
CIRCUIT
RAW(8)
DISPATCHER
RAW(8)
SERVER
RAW(8)
WAITER
RAW(8)
SADDR
RAW(8)
STATUS
VARCHAR2(16)
QUEUE
VARCHAR2(16)
MESSAGE0
NUMBER
MESSAGE1
NUMBER
MESSAGE2
NUMBER
MESSAGE3
NUMBER
MESSAGES
NUMBER
BYTES
NUMBER
BREAKS
NUMBER
PRESENTATION
VARCHAR2(257)
PCIRCUIT
RAW(8)
GV$CLASS_CACHE_TRANSFER: Synonym for GV_$CLASS_CACHE_TRANSFER
iSelfSchooling-SQL> desc GV$CLASS_CACHE_TRANSFER;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
CLASS
CHAR(10)
X_2_NULL
NUMBER
X_2_NULL_FORCED_WRITE
NUMBER
X_2_NULL_FORCED_STALE
NUMBER
X_2_S
NUMBER
X_2_S_FORCED_WRITE
NUMBER
S_2_NULL
NUMBER
S_2_NULL_FORCED_STALE
NUMBER
NULL_2_X
NUMBER
S_2_X
NUMBER
NULL_2_S
NUMBER
CR_TRANSFER
NUMBER
CURRENT_TRANSFER
NUMBER
GV$CLASS_PING: Synonym for GV_$CLASS_PING
iSelfSchooling-SQL> desc GV$CLASS_PING;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
CLASS
CHAR(10)
X_2_NULL
NUMBER
X_2_NULL_FORCED_WRITE
NUMBER
X_2_NULL_FORCED_STALE
NUMBER
X_2_S
NUMBER
X_2_S_FORCED_WRITE
NUMBER
X_2_SSX
NUMBER
X_2_SSX_FORCED_WRITE
NUMBER
S_2_NULL
NUMBER
S_2_NULL_FORCED_STALE
NUMBER
SS_2_NULL
NUMBER
SS_2_RLS
NUMBER
OP_2_SS
NUMBER
NULL_2_X
NUMBER
S_2_X
NUMBER
SSX_2_X
NUMBER
NULL_2_S
NUMBER
NULL_2_SS
NUMBER
GV$CLIENT_STATS: Synonym for GV_$CLIENT_STATS
iSelfSchooling-SQL> desc GV$CLIENT_STATS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
CLIENT_IDENTIFIER
VARCHAR2(64)
STAT_ID
NUMBER
STAT_NAME
VARCHAR2(64)
VALUE
NUMBER
GV$CLUSTER_INTERCONNECTS: Synonym for GV_$CLUSTER_INTERCONNECTS
iSelfSchooling-SQL> desc GV$CLUSTER_INTERCONNECTS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
NAME
VARCHAR2(15)
IP_ADDRESS
VARCHAR2(16)
IS_PUBLIC
VARCHAR2(3)
SOURCE
VARCHAR2(31)
GV$CONFIGURED_INTERCONNECTS: Synonym for GV_$CONFIGURED_INTERCONNECTS
iSelfSchooling-SQL> desc GV$CONFIGURED_INTERCONNECTS;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
NAME
VARCHAR2(15)
IP_ADDRESS
VARCHAR2(16)
IS_PUBLIC
VARCHAR2(3)
SOURCE
VARCHAR2(31)
GV$CONTEXT: Synonym for GV_$CONTEXT
iSelfSchooling-SQL> desc GV$CONTEXT;
Name
Null? Type
----------------------------- -------- --------------------
NAMESPACE
VARCHAR2(31)
ATTRIBUTE
VARCHAR2(31)
VALUE
VARCHAR2(4000)
GV$CONTROLFILE: Synonym for GV_$CONTROLFILE
iSelfSchooling-SQL> desc GV$CONTROLFILE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
STATUS
VARCHAR2(7)
NAME
VARCHAR2(513)
IS_RECOVERY_DEST_FILE
VARCHAR2(3)
BLOCK_SIZE
NUMBER
FILE_SIZE_BLKS
NUMBER
GV$CONTROLFILE_RECORD_SECTION:
Synonym
for GV_$CONTROLFILE_RECORD_SECTION
iSelfSchooling-SQL> desc GV$CONTROLFILE_RECORD_SECTION;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
TYPE
VARCHAR2(28)
RECORD_SIZE
NUMBER
RECORDS_TOTAL
NUMBER
RECORDS_USED
NUMBER
FIRST_INDEX
NUMBER
LAST_INDEX
NUMBER
LAST_RECID
NUMBER
GV$COPY_CORRUPTION: Synonym for GV_$COPY_CORRUPTION
iSelfSchooling-SQL> desc GV$COPY_CORRUPTION;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
RECID
NUMBER
STAMP
NUMBER
COPY_RECID
NUMBER
COPY_STAMP
NUMBER
FILE#
NUMBER
BLOCK#
NUMBER
BLOCKS
NUMBER
CORRUPTION_CHANGE#
NUMBER
MARKED_CORRUPT
VARCHAR2(3)
CORRUPTION_TYPE
VARCHAR2(9)
GV$CR_BLOCK_SERVER: Synonym for GV_$CR_BLOCK_SERVER
iSelfSchooling-SQL> desc GV$CR_BLOCK_SERVER;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
CR_REQUESTS
NUMBER
CURRENT_REQUESTS
NUMBER
DATA_REQUESTS
NUMBER
UNDO_REQUESTS
NUMBER
TX_REQUESTS
NUMBER
CURRENT_RESULTS
NUMBER
PRIVATE_RESULTS
NUMBER
ZERO_RESULTS
NUMBER
DISK_READ_RESULTS
NUMBER
FAIL_RESULTS
NUMBER
FAIRNESS_DOWN_CONVERTS
NUMBER
FAIRNESS_CLEARS NUMBER
FREE_GC_ELEMENTS
NUMBER
FLUSHES
NUMBER
FLUSHES_QUEUED
NUMBER
FLUSH_QUEUE_FULL
NUMBER
FLUSH_MAX_TIME
NUMBER
LIGHT_WORKS
NUMBER
ERRORS
NUMBER
GV$CURRENT_BLOCK_SERVER: Synonym for GV_$CURRENT_BLOCK_SERVER
iSelfSchooling-SQL> desc GV$CURRENT_BLOCK_SERVER;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
PIN1
NUMBER
PIN10
NUMBER
PIN100
NUMBER
PIN1000
NUMBER
PIN10000
NUMBER
FLUSH1
NUMBER
FLUSH10
NUMBER
FLUSH100
NUMBER
FLUSH1000
NUMBER
FLUSH10000
NUMBER
WRITE1
NUMBER
WRITE10
NUMBER
WRITE100
NUMBER
WRITE1000
NUMBER
WRITE10000
NUMBER
|