|
ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| DAT...
| ENQ...
| INS...
| LOG...
| PGA...
| ROW...
| SES...
| SQL...
| SYS...
GV$INSTANCE_RECOVERY: Synonym for GV_$INSTANCE_RECOVERY
iSelfSchooling-SQL> desc GV$INSTANCE_RECOVERY;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
RECOVERY_ESTIMATED_IOS
NUMBER
ACTUAL_REDO_BLKS
NUMBER
TARGET_REDO_BLKS
NUMBER
LOG_FILE_SIZE_REDO_BLKS
NUMBER
LOG_CHKPT_TIMEOUT_REDO_BLKS NUMBER
LOG_CHKPT_INTERVAL_REDO_BLKS
NUMBER
FAST_START_IO_TARGET_REDO_BLK NUMBER
S
TARGET_MTTR
NUMBER
ESTIMATED_MTTR
NUMBER
CKPT_BLOCK_WRITES
NUMBER
OPTIMAL_LOGFILE_SIZE
NUMBER
ESTD_CLUSTER_AVAILABLE_TIME NUMBER
WRITES_MTTR
NUMBER
WRITES_LOGFILE_SIZE
NUMBER
WRITES_LOG_CHECKPOINT_SETTING NUMBER
S
WRITES_OTHER_SETTINGS
NUMBER
WRITES_AUTOTUNE
NUMBER
WRITES_FULL_THREAD_CKPT
NUMBER
GV$JAVAPOOL: Synonym for GV_$JAVAPOOL
iSelfSchooling-SQL> desc GV$JAVAPOOL;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
CATEGORY
VARCHAR2(16)
MEMUSED
NUMBER
GV$JAVA_LIBRARY_CACHE_MEMORY:
Synonym
for GV_$JAVA_LIBRARY_CACHE_MEMORY
iSelfSchooling-SQL> desc GV$JAVA_LIBRARY_CACHE_MEMORY;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
LC_NAMESPACE
VARCHAR2(15)
LC_INUSE_MEMORY_OBJECTS
NUMBER
LC_INUSE_MEMORY_SIZE
NUMBER
LC_FREEABLE_MEMORY_OBJECTS NUMBER
LC_FREEABLE_MEMORY_SIZE
NUMBER
GV$JAVA_POOL_ADVICE: Synonym for GV_$JAVA_POOL_ADVICE
iSelfSchooling-SQL> desc GV$JAVA_POOL_ADVICE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
JAVA_POOL_SIZE_FOR_ESTIMATE NUMBER
JAVA_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$LATCH: Synonym for GV_$LATCH
iSelfSchooling-SQL> desc GV$LATCH;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ADDR
RAW(8)
LATCH#
NUMBER
LEVEL#
NUMBER
NAME
VARCHAR2(50)
HASH
NUMBER
GETS
NUMBER
MISSES
NUMBER
SLEEPS
NUMBER
IMMEDIATE_GETS
NUMBER
IMMEDIATE_MISSES NUMBER
WAITERS_WOKEN
NUMBER
WAITS_HOLDING_LATCH
NUMBER
SPIN_GETS
NUMBER
SLEEP1
NUMBER
SLEEP2
NUMBER
SLEEP3
NUMBER
SLEEP4
NUMBER
SLEEP5
NUMBER
SLEEP6
NUMBER
SLEEP7
NUMBER
SLEEP8
NUMBER
SLEEP9
NUMBER
SLEEP10
NUMBER
SLEEP11
NUMBER
WAIT_TIME
NUMBER
GV$LATCHHOLDER: Synonym for GV_$LATCHHOLDER
iSelfSchooling-SQL> desc GV$LATCHHOLDER;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
PID
NUMBER
SID
NUMBER
LADDR
RAW(8)
NAME
VARCHAR2(64)
GETS
NUMBER
GV$LATCHNAME: Synonym for GV_$LATCHNAME
iSelfSchooling-SQL> desc GV$LATCHNAME;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
LATCH#
NUMBER
NAME
VARCHAR2(50)
HASH
NUMBER
GV$LATCH_CHILDREN: Synonym for GV_$LATCH_CHILDREN
iSelfSchooling-SQL> desc GV$LATCH_CHILDREN;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ADDR
RAW(8)
LATCH#
NUMBER
CHILD#
NUMBER
LEVEL#
NUMBER
NAME
VARCHAR2(50)
HASH
NUMBER
GETS
NUMBER
MISSES
NUMBER
SLEEPS
NUMBER
IMMEDIATE_GETS
NUMBER
IMMEDIATE_MISSES
NUMBER
WAITERS_WOKEN
NUMBER
WAITS_HOLDING_LATCH
NUMBER
SPIN_GETS
NUMBER
SLEEP1
NUMBER
SLEEP2
NUMBER
SLEEP3
NUMBER
SLEEP4
NUMBER
SLEEP5
NUMBER
SLEEP6
NUMBER
SLEEP7
NUMBER
SLEEP8
NUMBER
SLEEP9
NUMBER
SLEEP10
NUMBER
SLEEP11
NUMBER
WAIT_TIME
NUMBER
GV$LATCH_MISSES: Synonym for GV_$LATCH_MISSES
iSelfSchooling-SQL> desc GV$LATCH_MISSES;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
PARENT_NAME
VARCHAR2(50)
WHERE
VARCHAR2(64)
NWFAIL_COUNT
NUMBER
SLEEP_COUNT
NUMBER
WTR_SLP_COUNT
NUMBER
LONGHOLD_COUNT
NUMBER
LOCATION
VARCHAR2(64)
GV$LATCH_PARENT: Synonym for GV_$LATCH_PARENT
iSelfSchooling-SQL> desc GV$LATCH_PARENT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ADDR
RAW(8)
LATCH#
NUMBER
LEVEL#
NUMBER
NAME
VARCHAR2(50)
HASH
NUMBER
GETS
NUMBER
MISSES
NUMBER
SLEEPS
NUMBER
IMMEDIATE_GETS
NUMBER
IMMEDIATE_MISSES
NUMBER
WAITERS_WOKEN
NUMBER
WAITS_HOLDING_LATCH
NUMBER
SPIN_GETS
NUMBER
SLEEP1
NUMBER
SLEEP2
NUMBER
SLEEP3
NUMBER
SLEEP4
NUMBER
SLEEP5
NUMBER
SLEEP6
NUMBER
SLEEP7
NUMBER
SLEEP8
NUMBER
SLEEP9
NUMBER
SLEEP10
NUMBER
SLEEP11
NUMBER
WAIT_TIME
NUMBER
GV$LIBRARYCACHE: Synonym for GV_$LIBRARYCACHE
iSelfSchooling-SQL> desc GV$LIBRARYCACHE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
NAMESPACE
VARCHAR2(15)
GETS
NUMBER
GETHITS
NUMBER
GETHITRATIO
NUMBER
PINS
NUMBER
PINHITS
< |