|
ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| DAT...
| ENQ...
| INS...
| LOG...
| PGA...
| ROW...
| SES...
| SQL...
| SYS...
GV$ENQUEUE_LOCK: Synonym for GV_$ENQUEUE_LOCK
iSelfSchooling-SQL> desc GV$ENQUEUE_LOCK;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ADDR
RAW(8)
KADDR
RAW(8)
SID
NUMBER
TYPE
VARCHAR2(2)
ID1
NUMBER
ID2
NUMBER
LMODE
NUMBER
REQUEST
NUMBER
CTIME
NUMBER
BLOCK
NUMBER
GV$ENQUEUE_STAT: Synonym for GV_$ENQUEUE_STAT
iSelfSchooling-SQL> desc GV$ENQUEUE_STAT;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
EQ_TYPE
VARCHAR2(2)
TOTAL_REQ#
NUMBER
TOTAL_WAIT#
NUMBER
SUCC_REQ# NUMBER
FAILED_REQ#
NUMBER
CUM_WAIT_TIME
NUMBER
GV$ENQUEUE_STATISTICS: Synonym for GV_$ENQUEUE_STATISTICS
iSelfSchooling-SQL> desc GV$ENQUEUE_STATISTICS;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
EQ_NAME
VARCHAR2(64)
EQ_TYPE
VARCHAR2(2)
REQ_REASON
VARCHAR2(64)
TOTAL_REQ#
NUMBER
TOTAL_WAIT#
NUMBER
SUCC_REQ#
NUMBER
FAILED_REQ#
NUMBER
CUM_WAIT_TIME
NUMBER
REQ_DESCRIPTION
VARCHAR2(4000)
EVENT#
NUMBER
GV$EVENTMETRIC: Synonym for GV_$EVENTMETRIC
iSelfSchooling-SQL> desc GV$EVENTMETRIC;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
BEGIN_TIME
DATE
END_TIME
DATE
INTSIZE_CSEC
NUMBER
EVENT#
NUMBER
EVENT_ID
NUMBER
NUM_SESS_WAITING
NUMBER
TIME_WAITED
NUMBER
WAIT_COUNT
NUMBER
GV$EVENT_HISTOGRAM: Synonym for GV_$EVENT_HISTOGRAM
iSelfSchooling-SQL> desc GV$EVENT_HISTOGRAM;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
EVENT#
NUMBER
EVENT
VARCHAR2(64)
WAIT_TIME_MILLI
NUMBER
WAIT_COUNT
NUMBER
GV$EVENT_NAME: Synonym for GV_$EVENT_NAME
iSelfSchooling-SQL> desc GV$EVENT_NAME;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
EVENT#
NUMBER
EVENT_ID
NUMBER
NAME
VARCHAR2(64)
PARAMETER1
VARCHAR2(64)
PARAMETER2
VARCHAR2(64)
PARAMETER3
VARCHAR2(64)
WAIT_CLASS_ID
NUMBER
WAIT_CLASS#
NUMBER
WAIT_CLASS
VARCHAR2(64)
GV$EXECUTION: Synonym for GV_$EXECUTION
iSelfSchooling-SQL> desc GV$EXECUTION;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
PID
NUMBER
DEPTH
NUMBER
FUNCTION
VARCHAR2(10)
TYPE
VARCHAR2(7)
NVALS
NUMBER
VAL1
NUMBER
VAL2
NUMBER
SEQH
NUMBER
SEQL
NUMBER
GV$FAST_START_SERVERS: Synonym for GV_$FAST_START_SERVERS
iSelfSchooling-SQL> desc GV$FAST_START_SERVERS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
STATE
VARCHAR2(11)
UNDOBLOCKSDONE
NUMBER
PID
NUMBER
XID
RAW(8)
GV$FAST_START_TRANSACTIONS: Synonym for GV_$FAST_START_TRANSACTIONS
iSelfSchooling-SQL> desc GV$FAST_START_TRANSACTIONS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
USN
NUMBER
SLT
NUMBER
SEQ
NUMBER
STATE
VARCHAR2(16)
UNDOBLOCKSDONE
NUMBER
UNDOBLOCKSTOTAL
NUMBER
PID
NUMBER
CPUTIME
NUMBER
PARENTUSN
NUMBER
PARENTSLT
NUMBER
PARENTSEQ
NUMBER
XID
RAW(8)
PXID
RAW(8)
RCVSERVERS
NUMBER
GV$FILEMETRIC: Synonym for GV_$FILEMETRIC
iSelfSchooling-SQL> desc GV$FILEMETRIC;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
BEGIN_TIME
DATE
END_TIME
DATE
INTSIZE_CSEC
NUMBER
FILE_ID
NUMBER
CREATION_TIME
NUMBER
AVERAGE_READ_TIME
NUMBER
AVERAGE_WRITE_TIME
NUMBER
PHYSICAL_READS
NUMBER
PHYSICAL_WRITES
NUMBER
PHYSICAL_BLOCK_READS
NUMBER
PHYSICAL_BLOCK_WRITES
NUMBER
GV$FILEMETRIC_HISTORY: Synonym for GV_$FILEMETRIC_HISTORY
iSelfSchooling-SQL> desc GV$FILEMETRIC_HISTORY;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
BEGIN_TIME
DATE
END_TIME
DATE
INTSIZE_CSEC
NUMBER
FILE_ID
NUMBER
CREATION_TIME
NUMBER
AVERAGE_READ_TIME
NUMBER
AVERAGE_WRITE_TIME
NUMBER
PHYSICAL_READS
NUMBER
PHYSICAL_WRITES
NUMBER
PHYSICAL_BLOCK_READS
NUMBER
PHYSICAL_BLOCK_WRITES
NUMBER
GV$FILESPACE_USAGE: Synonym for GV_$FILESPACE_USAGE
iSelfSchooling-SQL> desc GV$FILESPACE_USAGE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
TABLESPACE_ID
NUMBER
RFNO
NUMBER
ALLOCATED_SPACE
NUMBER
FILE_SIZE
NUMBER
FILE_MAXSIZE
NUMBER
CHANGESCN_BASE
NUMBER
CHANGESCN_WRAP
NUMBER
FLAG
NUMBER
GV$FILESTAT: Synonym for GV_$FILESTAT
iSelfSchooling-SQL> desc GV$FILESTAT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
FILE#
NUMBER
PHYRDS
NUMBER
PHYWRTS
NUMBER
PHYBLKRD
NUMBER
PHYBLKWRT
NUMBER
SINGLEBLKRDS
NUMBER
READTIM
NUMBER
WRITETIM
NUMBER
SINGLEBLKRDTIM
NUMBER
AVGIOTIM
NUMBER
LSTIOTIM
NUMBER
MINIOTIM
NUMBER
MAXIORTM
NUMBER
MAXIOWTM
NUMBER
GV$FILE_CACHE_TRANSFER: Synonym for GV_$FILE_CACHE_TRANSFER
</ |