|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| BUF...
| DEL...
| FLA...
| LOG...
| MTT...
| PX...
| SEG...
| SOR...
| SQL...
| TEM...
V$BUFFERED_SUBSCRIBERS: Synonym for V_$BUFFERED_SUBSCRIBERS
iSelfSchooling-SQL> desc V$BUFFERED_SUBSCRIBERS;
Name
Null? Type
----------------------------- -------- --------------------
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
V$BUFFER_POOL: Synonym for V_$BUFFER_POOL
iSelfSchooling-SQL> desc V$BUFFER_POOL;
Name
Null? Type
----------------------------- -------- --------------------
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
V$BUFFER_POOL_STATISTICS: Synonym for V_$BUFFER_POOL_STATISTICS
iSelfSchooling-SQL> desc V$BUFFER_POOL_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
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
V$CIRCUIT: Synonym for V_$CIRCUIT
iSelfSchooling-SQL> desc V$CIRCUIT;
Name
Null? Type
----------------------------- -------- --------------------
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)
V$CLASS_CACHE_TRANSFER: Synonym for V_$CLASS_CACHE_TRANSFER
iSelfSchooling-SQL> desc V$CLASS_CACHE_TRANSFER;
Name
Null? Type
----------------------------- -------- --------------------
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
V$CLASS_PING: Synonym for V_$CLASS_PING
iSelfSchooling-SQL> desc V$CLASS_PING;
Name
Null? Type
----------------------------- -------- --------------------
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
V$CLIENT_STATS: Synonym for V_$CLIENT_STATS
iSelfSchooling-SQL> desc V$CLIENT_STATS;
Name
Null?
Type
----------------------------- -------- --------------------
CLIENT_IDENTIFIER
VARCHAR2(64)
STAT_ID
NUMBER
STAT_NAME
VARCHAR2(64)
VALUE
NUMBER
V$CLUSTER_INTERCONNECTS: Synonym for V_$CLUSTER_INTERCONNECTS
iSelfSchooling-SQL> desc V$CLUSTER_INTERCONNECTS;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(15)
IP_ADDRESS
VARCHAR2(16)
IS_PUBLIC
VARCHAR2(3)
SOURCE
VARCHAR2(31)
V$CONFIGURED_INTERCONNECTS: Synonym for V_$CONFIGURED_INTERCONNECTS
iSelfSchooling-SQL> desc V$CONFIGURED_INTERCONNECTS;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(15)
IP_ADDRESS
VARCHAR2(16)
IS_PUBLIC
VARCHAR2(3)
SOURCE
VARCHAR2(31)
V$CONTEXT: Synonym for V_$CONTEXT
iSelfSchooling-SQL> desc V$CONTEXT;
Name
Null? Type
----------------------------- -------- --------------------
NAMESPACE
VARCHAR2(31)
ATTRIBUTE
VARCHAR2(31)
VALUE
VARCHAR2(4000)
V$CONTROLFILE: Synonym for V_$CONTROLFILE
iSelfSchooling-SQL> desc V$CONTROLFILE;
Name
Null? Type
----------------------------- -------- --------------------
STATUS
VARCHAR2(7)
NAME
VARCHAR2(513)
IS_RECOVERY_DEST_FILE
VARCHAR2(3)
BLOCK_SIZE
NUMBER
FILE_SIZE_BLKS
NUMBER
V$CONTROLFILE_RECORD_SECTION: Synonym for
V_$CONTROLFILE_RECORD_SECTION
iSelfSchooling-SQL> desc V$CONTROLFILE_RECORD_SECTION;
Name
Null? Type
----------------------------- -------- --------------------
TYPE
VARCHAR2(28)
RECORD_SIZE
NUMBER
RECORDS_TOTAL
NUMBER
RECORDS_USED
NUMBER
FIRST_INDEX |