|
ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| DAT...
| ENQ...
| INS...
| LOG...
| PGA...
| ROW...
| SES...
| SQL...
| SYS...
GV$SESSION_WAIT_HISTORY: Synonym for GV_$SESSION_WAIT_HISTORY
iSelfSchooling-SQL> desc GV$SESSION_WAIT_HISTORY;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
NUMBER
SEQ#
NUMBER
EVENT#
NUMBER
EVENT
VARCHAR2(64)
P1TEXT
VARCHAR2(64)
P1
NUMBER
P2TEXT
VARCHAR2(64)
P2
NUMBER
P3TEXT
VARCHAR2(64)
P3
NUMBER
WAIT_TIME
NUMBER
WAIT_COUNT
NUMBER
GV$SESSMETRIC: Synonym for GV_$SESSMETRIC
iSelfSchooling-SQL> desc GV$SESSMETRIC;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
BEGIN_TIME
DATE
END_TIME
DATE
INTSIZE_CSEC
NUMBER
SESSION_ID
NUMBER
SERIAL_NUM
NUMBER
CPU
NUMBER
PHYSICAL_READS
NUMBER
LOGICAL_READS
NUMBER
PGA_MEMORY
NUMBER
HARD_PARSES
NUMBER
SOFT_PARSES
NUMBER
PHYSICAL_READ_PCT
NUMBER
LOGICAL_READ_PCT
NUMBER
GV$SESSTAT: Synonym for GV_$SESSTAT
iSelfSchooling-SQL> desc GV$SESSTAT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
NUMBER
STATISTIC#
NUMBER
VALUE
NUMBER
GV$SESS_IO: Synonym for GV_$SESS_IO
iSelfSchooling-SQL> desc GV$SESS_IO;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
NUMBER
BLOCK_GETS
NUMBER
CONSISTENT_GETS
NUMBER
PHYSICAL_READS
NUMBER
BLOCK_CHANGES
NUMBER
CONSISTENT_CHANGES
NUMBER
GV$SESS_TIME_MODEL: Synonym for GV_$SESS_TIME_MODEL
iSelfSchooling-SQL> desc GV$SESS_TIME_MODEL;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
NUMBER
STAT_ID
NUMBER
STAT_NAME
VARCHAR2(64)
VALUE
NUMBER
GV$SES_OPTIMIZER_ENV: Synonym for GV_$SES_OPTIMIZER_ENV
iSelfSchooling-SQL> desc GV$SES_OPTIMIZER_ENV;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
NUMBER
ID
NUMBER
NAME
VARCHAR2(40)
ISDEFAULT
VARCHAR2(3)
VALUE
VARCHAR2(25)
GV$SGA: Synonym for GV_$SGA
iSelfSchooling-SQL> desc GV$SGA;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
NAME
VARCHAR2(20)
VALUE
NUMBER
GV$SGAINFO: Synonym for GV_$SGAINFO
iSelfSchooling-SQL> desc GV$SGAINFO;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
NAME
VARCHAR2(32)
BYTES
NUMBER
RESIZEABLE
VARCHAR2(3)
GV$SGASTAT: Synonym for GV_$SGASTAT
iSelfSchooling-SQL> desc GV$SGASTAT;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
POOL
VARCHAR2(12)
NAME
VARCHAR2(26)
BYTES
NUMBER
GV$SGA_CURRENT_RESIZE_OPS: Synonym for GV_$SGA_CURRENT_RESIZE_OPS
iSelfSchooling-SQL> desc GV$SGA_CURRENT_RESIZE_OPS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
COMPONENT
VARCHAR2(64)
OPER_TYPE
VARCHAR2(13)
OPER_MODE
VARCHAR2(9)
PARAMETER
VARCHAR2(80)
INITIAL_SIZE
NUMBER
TARGET_SIZE
NUMBER
CURRENT_SIZE
NUMBER
START_TIME
DATE
LAST_UPDATE_TIME
DATE
GV$SGA_DYNAMIC_COMPONENTS: Synonym for GV_$SGA_DYNAMIC_COMPONENTS
iSelfSchooling-SQL> desc GV$SGA_DYNAMIC_COMPONENTS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
COMPONENT
VARCHAR2(64)
CURRENT_SIZE
NUMBER
MIN_SIZE
NUMBER
MAX_SIZE
NUMBER
USER_SPECIFIED_SIZE
NUMBER
OPER_COUNT
NUMBER
LAST_OPER_TYPE
VARCHAR2(13)
LAST_OPER_MODE
VARCHAR2(9)
LAST_OPER_TIME
DATE
GRANULE_SIZE
NUMBER
GV$SGA_DYNAMIC_FREE_MEMORY: Synonym for GV_$SGA_DYNAMIC_FREE_MEMORY
iSelfSchooling-SQL> desc GV$SGA_DYNAMIC_FREE_MEMORY;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
CURRENT_SIZE
NUMBER
GV$SGA_RESIZE_OPS: Synonym for GV_$SGA_RESIZE_OPS
iSelfSchooling-SQL> desc GV$SGA_RESIZE_OPS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
COMPONENT
VARCHAR2(64)
OPER_TYPE
VARCHAR2(13)
OPER_MODE
VARCHAR2(9)
PARAMETER
VARCHAR2(80)
INITIAL_SIZE
NUMBER
TARGET_SIZE
NUMBER
FINAL_SIZE
NUMBER
STATUS
VARCHAR2(9)
START_TIME
DATE
END_TIME
DATE
iSelfSchooling-SQL> desc GV$SGA_RESIZE_OPS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
COMPONENT
VARCHAR2(64)
OPER_TYPE
VARCHAR2(13)
OPER_MODE
VARCHAR2(9)
PARAMETER
VARCHAR2(80)
INITIAL_SIZE
NUMBER
TARGET_SIZE
NUMBER
FINAL_SIZE
NUMBER
STATUS
VARCHAR2(9)
START_TIME
DATE
END_TIME
DATE
GV$SGA_TARGET_ADVICE: Synonym for GV_$SGA_TARGET_ADVICE
iSelfSchooling-SQL> desc GV$SGA_TARGET_ADVICE;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SGA_SIZE
NUMBER
SGA_SIZE_FACTOR
NUMBER
ESTD_DB_TIME
NUMBER
ESTD_DB_TIME_FACTOR
NUMBER
ESTD_PHYSICAL_READS
NUMBER
GV$SHARED_POOL_ADVICE: Synonym for GV_$SHARED_POOL_ADVICE
iSelfSchooling-SQL> desc GV$SHARED_POOL_ADVICE;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SHARED_POOL_SIZE_FOR_ESTIMATE NUMBER
SHARED_POOL_SIZE_FACTOR
NUMBER
ESTD_LC_SIZE
NUMBER
ESTD_LC_MEMORY_OBJECTS
NUMBER
ESTD_LC_TIME_SAVED
NUMBER
ESTD_LC_TIME_SAVED_FACTOR
NUMBER
ESTD_LC_LOAD_TIME
NUMBER
ESTD_LC_LOAD_TIME_FACTOR
NUMBER
ESTD_LC_MEMORY_OBJECT_HITS
NUMBER
GV$SHARED_POOL_RESERVED: Synonym for GV_$SHARED_POOL_RESERVED
|