|
ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| DAT...
| ENQ...
| INS...
| LOG...
| PGA...
| ROW...
| SES...
| SQL...
| SYS...
GV$ROWCACHE: Synonym for GV_$ROWCACHE
iSelfSchooling-SQL> desc GV$ROWCACHE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
CACHE#
NUMBER
TYPE
VARCHAR2(11)
SUBORDINATE#
NUMBER
PARAMETER
VARCHAR2(32)
COUNT
NUMBER
USAGE
NUMBER
FIXED
NUMBER
GETS
NUMBER
GETMISSES
NUMBER
SCANS
NUMBER
SCANMISSES
NUMBER
SCANCOMPLETES
NUMBER
MODIFICATIONS
NUMBER
FLUSHES
NUMBER
DLM_REQUESTS
NUMBER
DLM_CONFLICTS
NUMBER
DLM_RELEASES
NUMBER
GV$ROWCACHE_PARENT: Synonym for GV_$ROWCACHE_PARENT
iSelfSchooling-SQL> desc GV$ROWCACHE_PARENT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
INDX
NUMBER
HASH
NUMBER
ADDRESS
RAW(8)
CACHE#
NUMBER
CACHE_NAME
VARCHAR2(64)
EXISTENT
VARCHAR2(1)
LOCK_MODE
NUMBER
LOCK_REQUEST
NUMBER
TXN
RAW(8)
SADDR
RAW(8)
INST_LOCK_REQUEST
NUMBER
INST_LOCK_RELEASE
NUMBER
INST_LOCK_TYPE
VARCHAR2(2)
INST_LOCK_ID1
RAW(4)
INST_LOCK_ID2
RAW(4)
KEY
RAW(100)
GV$ROWCACHE_SUBORDINATE: Synonym for GV_$ROWCACHE_SUBORDINATE
iSelfSchooling-SQL> desc GV$ROWCACHE_SUBORDINATE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
INDX
NUMBER
HASH
NUMBER
ADDRESS
RAW(8)
CACHE#
NUMBER
SUBCACHE#
NUMBER
SUBCACHE_NAME
VARCHAR2(64)
EXISTENT
VARCHAR2(1)
PARENT
RAW(8)
KEY
RAW(100)
GV$RSRC_CONSUMER_GROUP: Synonym for GV_$RSRC_CONSUMER_GROUP
iSelfSchooling-SQL> desc GV$RSRC_CONSUMER_GROUP;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
NAME
VARCHAR2(32)
ID
NUMBER
ACTIVE_SESSIONS
NUMBER
EXECUTION_WAITERS
NUMBER
REQUESTS
NUMBER
CPU_WAIT_TIME
NUMBER
CPU_WAITS
NUMBER
CONSUMED_CPU_TIME
NUMBER
YIELDS
NUMBER
QUEUE_LENGTH
NUMBER
CURRENT_UNDO_CONSUMPTION
NUMBER
ACTIVE_SESSION_LIMIT_HIT
NUMBER
SESSION_SWITCHES_IN
NUMBER
SESSION_SWITCHES_OUT
NUMBER
UNDO_LIMIT_HIT
NUMBER
SQL_CANCELED
NUMBER
ACTIVE_SESSIONS_KILLED
NUMBER
IDLE_SESSIONS_KILLED
NUMBER
IDLE_BLKR_SESSIONS_KILLED
NUMBER
QUEUED_TIME
NUMBER
QUEUE_TIME_OUTS
NUMBER
GV$RSRC_CONSUMER_GROUP_CPU_MTH:
Synonym
for GV_$RSRC_CONSUME_GROUP_CPU_MTH
iSelfSchooling-SQL> desc GV$RSRC_CONSUMER_GROUP_CPU_MTH;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
NAME
VARCHAR2(40)
GV$RSRC_CONS_GROUP_HISTORY: Synonym for GV_$RSRC_CONS_GROUP_HISTORY
iSelfSchooling-SQL> desc GV$RSRC_CONS_GROUP_HISTORY;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SEQUENCE#
NUMBER
ID
NUMBER
NAME
VARCHAR2(30)
REQUESTS
NUMBER
CPU_WAIT_TIME
NUMBER
CPU_WAITS
NUMBER
CONSUMED_CPU_TIME
NUMBER
YIELDS
NUMBER
ACTIVE_SESS_LIMIT_HIT
NUMBER
UNDO_LIMIT_HIT
NUMBER
SESSION_SWITCHES_IN
NUMBER
SESSION_SWITCHES_OUT
NUMBER
SQL_CANCELED
NUMBER
ACTIVE_SESS_KILLED
NUMBER
IDLE_SESS_KILLED
NUMBER
IDLE_BLKR_SESS_KILLED
NUMBER
QUEUED_TIME
NUMBER
QUEUE_TIME_OUTS
NUMBER
GV$RSRC_PLAN: Synonym for GV_$RSRC_PLAN
iSelfSchooling-SQL> desc GV$RSRC_PLAN;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
ID
NUMBER
NAME
VARCHAR2(32)
IS_TOP_PLAN
VARCHAR2(5)
GV$RSRC_PLAN_CPU_MTH: Synonym for GV_$RSRC_PLAN_CPU_MTH
iSelfSchooling-SQL> desc GV$RSRC_PLAN_CPU_MTH;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
NAME
VARCHAR2(40)
GV$RSRC_PLAN_HISTORY: Synonym for GV_$RSRC_PLAN_HISTORY
iSelfSchooling-SQL> desc GV$RSRC_PLAN_HISTORY;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SEQUENCE#
NUMBER
ID
NUMBER
NAME
VARCHAR2(30)
START_TIME
DATE
END_TIME
DATE
ENABLED_BY_SCHEDULER
VARCHAR2(5)
WINDOW_NAME
VARCHAR2(30)
ALLOWED_AUTOMATED_SWITCHES VARCHAR2(5)
GV$RSRC_SESSION_INFO: Synonym for GV_$RSRC_SESSION_INFO
iSelfSchooling-SQL> desc GV$RSRC_SESSION_INFO;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
NUMBER
CURRENT_CONSUMER_GROUP_ID
VARCHAR2(40)
ORIG_CONSUMER_GROUP_ID
VARCHAR2(40)
MAPPING_ATTRIBUTE
VARCHAR2(32)
MAPPED_CONSUMER_GROUP
VARCHAR2(32)
STATE
VARCHAR2(32)
ACTIVE
VARCHAR2(5)
CURRENT_IDLE_TIME
NUMBER
CURRENT_CPU_WAIT_TIME
NUMBER
CPU_WAIT_TIME
NUMBER
CURRENT_CPU_WAITS
NUMBER
CPU_WAITS
NUMBER
CURRENT_CONSUMED_CPU_TIME
NUMBER
CONSUMED_CPU_TIME
NUMBER
CURRENT_ACTIVE_TIME
NUMBER
ACTIVE_TIME
NUMBER
CURRENT_QUEUED_TIME
NUMBER
QUEUED_TIME
NUMBER
CURRENT_YIELDS
NUMBER
YIELDS
NUMBER
CURRENT_UNDO_CONSUMPTION
NUMBER
MAX_UNDO_CONSUMPTION
NUMBER
SQL_CANCELED
NUMBER
QUEUE_TIME_OUTS
NUMBER
ESTIMATED_EXECUTION_LIMIT_HIT NUMBER
GV$RULE: Synonym for GV_$RULE
iSelfSchooling-SQL> desc GV$RULE;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
RULE_SET_OBJECT_ID
NUMBER
EVALUATION_CONTEXT_OBJECT_ID NUMBER
RULE_OWNER
VARCHAR2(30)
RULE_NAME
VARCHAR2(30)
RULE_CONDITION
VARCHAR2(200)
TRUE_HITS
NUMBER
MAYBE_HITS
NUMBER
SQL_EVALUATIONS
NUMBER
GV$RULE_SET: Synonym for GV_$RULE_SET
iSelfSchooling-SQL> desc GV$RULE_SET;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
OWNER
VARCHAR2(30)
|