|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| BUF...
| DEL...
| FLA...
| LOG...
| MTT...
| PX...
| SEG...
| SOR...
| SQL...
| TEM...
V$PX_SESSTAT: Synonym for V_$PX_SESSTAT
iSelfSchooling-SQL> desc V$PX_SESSTAT;
Name
Null? Type
----------------------------- -------- --------------------
SADDR
RAW(8)
SID
NUMBER
SERIAL#
NUMBER
QCSID
NUMBER
QCSERIAL#
NUMBER
QCINST_ID
NUMBER
SERVER_GROUP
NUMBER
SERVER_SET
NUMBER
SERVER#
NUMBER
DEGREE
NUMBER
REQ_DEGREE
NUMBER
STATISTIC#
NUMBER
VALUE
NUMBER
V$QUEUE: Synonym for V_$QUEUE
iSelfSchooling-SQL> desc V$QUEUE;
Name
Null? Type
----------------------------- -------- --------------------
PADDR
RAW(8)
TYPE
VARCHAR2(10)
QUEUED
NUMBER
WAIT
NUMBER
TOTALQ
NUMBER
V$QUEUEING_MTH: Synonym for V_$QUEUEING_MTH
iSelfSchooling-SQL> desc V$QUEUEING_MTH;
Name
Null?
Type
----------------------------- -------- --------------------
NAME
VARCHAR2(40)
V$RECOVERY_FILE_DEST: Synonym for V_$RECOVERY_FILE_DEST
iSelfSchooling-SQL> desc V$RECOVERY_FILE_DEST;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(513)
SPACE_LIMIT
NUMBER
SPACE_USED
NUMBER
SPACE_RECLAIMABLE
NUMBER
NUMBER_OF_FILES
NUMBER
V$RECOVERY_FILE_STATUS: Synonym for V_$RECOVERY_FILE_STATUS
iSelfSchooling-SQL> desc V$RECOVERY_FILE_STATUS;
Name
Null? Type
----------------------------- -------- --------------------
FILENUM
NUMBER
FILENAME
VARCHAR2(513)
STATUS
VARCHAR2(13)
V$RECOVERY_LOG: Synonym for V_$RECOVERY_LOG
iSelfSchooling-SQL> desc V$RECOVERY_LOG;
Name
Null? Type
----------------------------- -------- --------------------
THREAD#
NUMBER
SEQUENCE#
NUMBER
TIME
DATE
ARCHIVE_NAME
VARCHAR2(513)
V$RECOVERY_PROGRESS: Synonym for V_$RECOVERY_PROGRESS
iSelfSchooling-SQL> desc V$RECOVERY_PROGRESS;
Name
Null? Type
----------------------------- -------- --------------------
START_TIME
DATE
TYPE
VARCHAR2(64)
ITEM
VARCHAR2(32)
UNITS
VARCHAR2(32)
SOFAR
NUMBER
TOTAL
NUMBER
TIMESTAMP
DATE
V$RECOVERY_STATUS: Synonym for V_$RECOVERY_STATUS
iSelfSchooling-SQL> desc V$RECOVERY_STATUS;
Name
Null? Type
----------------------------- -------- --------------------
RECOVERY_CHECKPOINT
DATE
THREAD
NUMBER
SEQUENCE_NEEDED
NUMBER
SCN_NEEDED
VARCHAR2(16)
TIME_NEEDED
DATE
PREVIOUS_LOG_NAME
VARCHAR2(513)
PREVIOUS_LOG_STATUS
VARCHAR2(13)
REASON
VARCHAR2(13)
V$RECOVER_FILE: Synonym for V_$RECOVER_FILE
iSelfSchooling-SQL> desc V$RECOVER_FILE;
Name
Null? Type
----------------------------- -------- --------------------
FILE#
NUMBER
ONLINE
VARCHAR2(7)
ONLINE_STATUS
VARCHAR2(7)
ERROR
VARCHAR2(18)
CHANGE#
NUMBER
TIME
DATE
V$REPLPROP: Synonym for V_$REPLPROP
iSelfSchooling-SQL> desc V$REPLPROP;
Name
Null? Type
----------------------------- -------- --------------------
SID
NUMBER
SERIAL#
NUMBER
NAME
VARCHAR2(71)
DBLINK
VARCHAR2(128)
STATE
VARCHAR2(12)
XID
VARCHAR2(22)
SEQUENCE
NUMBER
V$REPLQUEUE: Synonym for V_$REPLQUEUE
iSelfSchooling-SQL> desc V$REPLQUEUE;
Name
Null? Type
----------------------------- -------- --------------------
TXNS_ENQUEUED
NUMBER
CALLS_ENQUEUED
NUMBER
TXNS_PURGED
NUMBER
LAST_ENQUEUE_TIME
DATE
LAST_PURGE_TIME
DATE
V$REQDIST: Synonym for V_$REQDIST
iSelfSchooling-SQL> desc V$REQDIST;
Name
Null? Type
----------------------------- -------- --------------------
BUCKET
NUMBER
COUNT
NUMBER
V$RESERVED_WORDS: Synonym for V_$RESERVED_WORDS
iSelfSchooling-SQL> desc V$RESERVED_WORDS;
Name
Null? Type
----------------------------- -------- --------------------
KEYWORD
VARCHAR2(30)
LENGTH
NUMBER
RESERVED
VARCHAR2(1)
RES_TYPE
VARCHAR2(1)
RES_ATTR
VARCHAR2(1)
RES_SEMI
VARCHAR2(1)
DUPLICATE
VARCHAR2(1)
V$RESOURCE: Synonym for V_$RESOURCE
iSelfSchooling-SQL> desc V$RESOURCE;
Name
Null?
Type
----------------------------- -------- --------------------
ADDR
RAW(8)
TYPE
VARCHAR2(2)
ID1
NUMBER
ID2
NUMBER
V$RESOURCE_LIMIT: Synonym for V_$RESOURCE_LIMIT
iSelfSchooling-SQL> desc V$RESOURCE_LIMIT;
Name
Null? Type
----------------------------- -------- --------------------
RESOURCE_NAME
VARCHAR2(30)
CURRENT_UTILIZATION
NUMBER
MAX_UTILIZATION
NUMBER
INITIAL_ALLOCATION
VARCHAR2(10)
LIMIT_VALUE
VARCHAR2(10)
V$RESTORE_POINT: Synonym for V_$RESTORE_POINT
iSelfSchooling-SQL> desc V$RESTORE_POINT;
Name
Null? Type
----------------------------- -------- --------------------
SCN
NUMBER
DATABASE_INCARNATION#
NUMBER
GUARANTEE_FLASHBACK_DATABASE VARCHAR2(3)
STORAGE_SIZE
NUMBER
TIME
TIMESTAMP(9)
NAME
VARCHAR2(128)
V$RESUMABLE: Synonym for V_$RESUMABLE
iSelfSchooling-SQL> desc V$RESUMABLE;
Name
Null? Type
----------------------------- -------- --------------------
ADDR
RAW(8)
SID
NUMBER
ENABLED
VARCHAR2(3)
STATUS
VARCHAR2(9)
TIMEOUT
NUMBER
SUSPEND_TIME
VARCHAR2(20)
RESUME_TIME
VARCHAR2(20)
NAME
VARCHAR2(4000)
ERROR_NUMBER
NUMBER
ERROR_PARAMETER1
VARCHAR2(80)
ERROR_PARAMETER2
VARCHAR2(80)
ERROR_PARAMETER3
VARCHAR2(80)
ERROR_PARAMETER4
VARCHAR2(80)
ERROR_PARAMETER5
VARCHAR2(80)
ERROR_MSG |