|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
2PC...
| APP...
| CAP...
| EXP...
| HIS...
| HIS...
| IND...
| LOC...
| OPA...
| REC...
| REP...
| SCH...
| STR...
| TAB...
DBA_HIST_FILESTATXS: Datafile Historical Statistics Information
iSelfSchooling-SQL> desc DBA_HIST_FILESTATXS;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NUMBER
DBID
NUMBER
INSTANCE_NUMBER
NUMBER
FILE#
NUMBER
CREATION_CHANGE#
NUMBER
FILENAME
VARCHAR2(513)
TS#
NUMBER
TSNAME
VARCHAR2(30)
BLOCK_SIZE
NUMBER
PHYRDS
NUMBER
PHYWRTS
NUMBER
SINGLEBLKRDS
NUMBER
READTIM
NUMBER
WRITETIM
NUMBER
SINGLEBLKRDTIM
NUMBER
PHYBLKRD
NUMBER
PHYBLKWRT
NUMBER
WAIT_COUNT
NUMBER
TIME
NUMBER
DBA_HIST_INSTANCE_RECOVERY: Instance Recovery Historical Statistics
Information
iSelfSchooling-SQL> desc DBA_HIST_INSTANCE_RECOVERY;
Name
Null?
Type
----------------------------- -------- --------------------
SNAP_ID
NOT NULL NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL 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
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
WRITES_OTHER_SETTINGS
NUMBER
WRITES_AUTOTUNE
NUMBER
WRITES_FULL_THREAD_CKPT
NUMBER
DBA_HIST_INST_CACHE_TRANSFER:
Instance
Cache Transfer Historical Statistics
iSelfSchooling-SQL> desc DBA_HIST_INST_CACHE_TRANSFER;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NUMBER
DBID
NUMBER
INSTANCE_NUMBER
NUMBER
INSTANCE
NUMBER
CLASS
VARCHAR2(18)
CR_BLOCK
NUMBER
CR_BUSY
NUMBER
CR_CONGESTED
NUMBER
CURRENT_BLOCK
NUMBER
CURRENT_BUSY
NUMBER
CURRENT_CONGESTED
NUMBER
DBA_HIST_JAVA_POOL_ADVICE: Java Pool Advice History
iSelfSchooling-SQL> desc DBA_HIST_JAVA_POOL_ADVICE;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NOT NULL NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
JAVA_POOL_SIZE_FOR_ESTIMATE
NOT NULL 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
DBA_HIST_LATCH: Latch Historical Statistics Information
iSelfSchooling-SQL> desc DBA_HIST_LATCH;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NUMBER
DBID
NUMBER
INSTANCE_NUMBER
NUMBER
LATCH_HASH
NUMBER
LATCH_NAME
VARCHAR2(64)
LEVEL#
NUMBER
GETS
NUMBER
MISSES
NUMBER
SLEEPS
NUMBER
IMMEDIATE_GETS
NUMBER
IMMEDIATE_MISSES
NUMBER
SPIN_GETS
NUMBER
SLEEP1
NUMBER
SLEEP2
NUMBER
SLEEP3
NUMBER
SLEEP4
NUMBER
WAIT_TIME
NUMBER
DBA_HIST_LATCH_CHILDREN: Latch Children Historical Statistics Information
iSelfSchooling-SQL> desc DBA_HIST_LATCH_CHILDREN;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NUMBER
DBID
NUMBER
INSTANCE_NUMBER
NUMBER
LATCH_HASH
NUMBER
LATCH_NAME
VARCHAR2(64)
CHILD#
NUMBER
GETS
NUMBER
MISSES
NUMBER
SLEEPS
NUMBER
IMMEDIATE_GETS
NUMBER
IMMEDIATE_MISSES
NUMBER
SPIN_GETS
NUMBER
SLEEP1
NUMBER
SLEEP2
NUMBER
SLEEP3
NUMBER
SLEEP4
NUMBER
WAIT_TIME
NUMBER
DBA_HIST_LATCH_MISSES_SUMMARY:
Latch
Misses Summary Historical Statistics Information
iSelfSchooling-SQL> desc DBA_HIST_LATCH_MISSES_SUMMARY;
Name
Null? Type
-----------------------------
-------- --------------------
SNAP_ID
NUMBER
DBID
NUMBER
INSTANCE_NUMBER
NUMBER
PARENT_NAME
VARCHAR2(50)
WHERE_IN_CODE
VARCHAR2(64)
NWFAIL_COUNT
NUMBER
SLEEP_COUNT
NUMBER
WTR_SLP_COUNT
NUMBER
DBA_HIST_LATCH_NAME: Latch Names
iSelfSchooling-SQL> desc DBA_HIST_LATCH_NAME;
Name
Null? Type
----------------------------- -------- --------------------
DBID
NOT NULL NUMBER
LATCH_HASH
NOT NULL NUMBER
LATCH_NAME
NOT NULL VARCHAR2(64)
DBA_HIST_LATCH_PARENT: Latch Parent Historical Historical Statistics
Information
iSelfSchooling-SQL> desc DBA_HIST_LATCH_PARENT;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NUMBER
DBID
NUMBER
INSTANCE_NUMBER
NUMBER
LATCH_HASH
NUMBER
LATCH_NAME
VARCHAR2(64)
LEVEL#
NUMBER
GETS
NUMBER
MISSES
NUMBER
SLEEPS
NUMBER
IMMEDIATE_GETS
NUMBER
IMMEDIATE_MISSES
NUMBER
SPIN_GETS
NUMBER
SLEEP1
NUMBER
SLEEP2
NUMBER
SLEEP3
NUMBER
SLEEP4
NUMBER
WAIT_TIME
NUMBER
DBA_HIST_LIBRARYCACHE: Library Cache Historical Statistics Information
iSelfSchooling-SQL> desc DBA_HIST_LIBRARYCACHE;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NOT
NULL NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
NAMESPACE
NOT NULL VARCHAR2(15)
GETS
NUMBER
GETHITS
NUMBER
PINS
NUMBER
PINHITS
NUMBER
RELOADS
NUMBER
INVALIDATIONS
NUMBER
DLM_LOCK_REQUESTS
NUMBER
DLM_PIN_REQUESTS
NUMBER
DLM_PIN_RELEASES
NUMBER
DLM_INVALIDATION_REQUESTS
NUMBER
DLM_INVALIDATIONS
NUMBER
DBA_HIST_LOG: Log Historical Statistics Information
iSelfSchooling-SQL> desc DBA_HIST_LOG;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NOT NULL NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
GROUP#
NOT NULL NUMBER
THREAD# |