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#
NOT NULL NUMBER
SEQUENCE#
NOT NULL NUMBER
BYTES
NUMBER
MEMBERS
NUMBER
ARCHIVED
VARCHAR2(3)
STATUS
VARCHAR2(16)
FIRST_CHANGE#
NUMBER
FIRST_TIME
DATE
DBA_HIST_METRIC_NAME: Segment Names
iSelfSchooling-SQL> desc DBA_HIST_METRIC_NAME;
Name
Null? Type
----------------------------- -------- --------------------
DBID
NOT NULL NUMBER
GROUP_ID
NOT NULL NUMBER
GROUP_NAME
VARCHAR2(64)
METRIC_ID
NOT NULL NUMBER
METRIC_NAME
NOT NULL VARCHAR2(64)
METRIC_UNIT
NOT NULL VARCHAR2(64)
DBA_HIST_MTTR_TARGET_ADVICE: Mean-Time-To-Recover Target Advice History
iSelfSchooling-SQL> desc DBA_HIST_MTTR_TARGET_ADVICE;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NOT NULL NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
MTTR_TARGET_FOR_ESTIMATE
NUMBER
ADVICE_STATUS
VARCHAR2(5)
DIRTY_LIMIT
NUMBER
ESTD_CACHE_WRITES
NUMBER
ESTD_CACHE_WRITE_FACTOR
NUMBER
ESTD_TOTAL_WRITES
NUMBER
ESTD_TOTAL_WRITE_FACTOR
NUMBER
ESTD_TOTAL_IOS
NUMBER
ESTD_TOTAL_IO_FACTOR
NUMBER
DBA_HIST_OPTIMIZER_ENV: Optimizer Environment Information
iSelfSchooling-SQL> desc DBA_HIST_OPTIMIZER_ENV;
Name
Null? Type
----------------------------- -------- --------------------
DBID
NOT NULL NUMBER
OPTIMIZER_ENV_HASH_VALUE
NOT NULL NUMBER
OPTIMIZER_ENV
RAW(1000)
DBA_HIST_OSSTAT: Operating System Historical Statistics
Information
iSelfSchooling-SQL> desc DBA_HIST_OSSTAT;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NUMBER
DBID
NUMBER
INSTANCE_NUMBER
NUMBER
STAT_ID
NUMBER
STAT_NAME
VARCHAR2(64)
VALUE
NUMBER
DBA_HIST_OSSTAT_NAME: Operating System Statistic Names
iSelfSchooling-SQL> desc DBA_HIST_OSSTAT_NAME;
Name
Null? Type
----------------------------- -------- --------------------
DBID
NOT NULL NUMBER
STAT_ID
NOT NULL NUMBER
STAT_NAME
NOT NULL VARCHAR2(64)
DBA_HIST_PARAMETER: Parameter Historical Statistics Information
iSelfSchooling-SQL> desc DBA_HIST_PARAMETER;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NUMBER
DBID
NUMBER
INSTANCE_NUMBER
NUMBER
PARAMETER_HASH
NUMBER
PARAMETER_NAME
VARCHAR2(64)
VALUE
VARCHAR2(512)
ISDEFAULT
VARCHAR2(9)
ISMODIFIED
VARCHAR2(10)
DBA_HIST_PARAMETER_NAME: Parameter Names
iSelfSchooling-SQL> desc DBA_HIST_PARAMETER_NAME;
Name
Null? Type
----------------------------- -------- --------------------
DBID
NOT NULL NUMBER
PARAMETER_HASH NOT
NULL NUMBER
PARAMETER_NAME
NOT NULL VARCHAR2(64)
DBA_HIST_PGASTAT: PGA Historical Statistics Information
iSelfSchooling-SQL> desc DBA_HIST_PGASTAT;
Name
Null? Type
-----------------------------
-------- --------------------
SNAP_ID
NOT NULL NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
NAME
NOT NULL VARCHAR2(64)
VALUE
NUMBER
DBA_HIST_PGA_TARGET_ADVICE: PGA Target Advice History
iSelfSchooling-SQL> desc DBA_HIST_PGA_TARGET_ADVICE;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NOT NULL
NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
PGA_TARGET_FOR_ESTIMATE
NOT NULL NUMBER
PGA_TARGET_FACTOR
NUMBER
ADVICE_STATUS
VARCHAR2(3)
BYTES_PROCESSED
NUMBER
ESTD_EXTRA_BYTES_RW
NUMBER
ESTD_PGA_CACHE_HIT_PERCENTAGE NUMBER
ESTD_OVERALLOC_COUNT
NUMBER
DBA_HIST_PROCESS_MEM_SUMMARY:
Process
Memory Historical Summary Information
iSelfSchooling-SQL> desc DBA_HIST_PROCESS_MEM_SUMMARY;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NOT NULL NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
CATEGORY
NOT NULL VARCHAR2(15)
NUM_PROCESSES
NUMBER
NON_ZERO_ALLOCS
NUMBER
USED_TOTAL
NUMBER
ALLOCATED_TOTAL
NUMBER
ALLOCATED_AVG
NUMBER
ALLOCATED_STDDEV
NUMBER
ALLOCATED_MAX
NUMBER
MAX_ALLOCATED_MAX
NUMBER
DBA_HIST_RESOURCE_LIMIT: Resource Limit Historical Statistics Information
iSelfSchooling-SQL> desc DBA_HIST_RESOURCE_LIMIT;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NOT NULL NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
RESOURCE_NAME
NOT NULL VARCHAR2(30)
CURRENT_UTILIZATION
NUMBER
MAX_UTILIZATION
NUMBER
INITIAL_ALLOCATION
VARCHAR2(10)
LIMIT_VALUE
VARCHAR2(10)
DBA_HIST_ROWCACHE_SUMMARY: Row Cache Historical Statistics Information
Summary
iSelfSchooling-SQL> desc DBA_HIST_ROWCACHE_SUMMARY;
Name
Null?
Type
----------------------------- -------- --------------------
SNAP_ID
NUMBER
DBID
NUMBER
INSTANCE_NUMBER
NUMBER
PARAMETER
VARCHAR2(32)
TOTAL_USAGE
NUMBER
USAGE
NUMBER
GETS
NUMBER
GETMISSES
NUMBER
SCANS
NUMBER
SCANMISSES
NUMBER
SCANCOMPLETES
NUMBER
MODIFICATIONS
NUMBER
FLUSHES
NUMBER
DLM_REQUESTS
NUMBER
DLM_CONFLICTS
NUMBER
DLM_RELEASES
NUMBER
DBA_HIST_RULE_SET: Rule sets historical statistics information
iSelfSchooling-SQL> desc DBA_HIST_RULE_SET;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NOT NULL NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
STARTUP_TIME
NOT NULL DATE
CPU_TIME
NUMBER
ELAPSED_TIME
NUMBER
EVALUATIONS
NUMBER
SQL_FREE_EVALUATIONS
NUMBER
SQL_EXECUTIONS
NUMBER
RELOADS
NUMBER
DBA_HIST_SEG_STAT: Historical Statistics Information
iSelfSchooling-SQL> desc DBA_HIST_SEG_STAT;
Name
Null? Type
-----------------------------
-------- --------------------
SNAP_ID
NUMBER
DBID
NUMBER
INSTANCE_NUMBER
NUMBER
TS#
NUMBER
OBJ#
NUMBER
DATAOBJ#
NUMBER
LOGICAL_READS_TOTAL
NUMBER
LOGICAL_READS_DELTA
NUMBER
BUFFER_BUSY_WAITS_TOTAL
NUMBER
BUFFER_BUSY_WAITS_DELTA
NUMBER
DB_BLOCK_CHANGES_TOTAL
NUMBER
DB_BLOCK_CHANGES_DELTA
NUMBER
PHYSICAL_READS_TOTAL
NUMBER
PHYSICAL_READS_DELTA
NUMBER
PHYSICAL_WRITES_TOTAL
NUMBER
PHYSICAL_WRITES_DELTA NUMBER
PHYSICAL_READS_DIRECT_TOTAL NUMBER
PHYSICAL_READS_DIRECT_DELTA NUMBER
PHYSICAL_WRITES_DIRECT_TOTAL NUMBER
PHYSICAL_WRITES_DIRECT_DELTA NUMBER
ITL_WAITS_TOTAL
NUMBER
ITL_WAITS_DELTA
NUMBER
ROW_LOCK_WAITS_TOTAL
NUMBER
ROW_LOCK_WAITS_DELTA
NUMBER
GC_CR_BLOCKS_SERVED_TOTAL
NUMBER
GC_CR_BLOCKS_SERVED_DELTA
NUMBER
GC_CU_BLOCKS_SERVED_TOTAL
NUMBER
GC_CU_BLOCKS_SERVED_DELTA
NUMBER
GC_BUFFER_BUSY_TOTAL
NUMBER
GC_BUFFER_BUSY_DELTA
NUMBER
GC_CR_BLOCKS_RECEIVED_TOTAL NUMBER
GC_CR_BLOCKS_RECEIVED_DELTA NUMBER
GC_CU_BLOCKS_RECEIVED_TOTAL NUMBER
GC_CU_BLOCKS_RECEIVED_DELTA NUMBER
SPACE_USED_TOTAL
NUMBER
SPACE_USED_DELTA
NUMBER
SPACE_ALLOCATED_TOTAL
NUMBER
SPACE_ALLOCATED_DELTA
NUMBER
TABLE_SCANS_TOTAL
NUMBER
TABLE_SCANS_DELTA
NUMBER
DBA_HIST_SEG_STAT_OBJ: Segment Names
iSelfSchooling-SQL> desc DBA_HIST_SEG_STAT_OBJ;
Name
Null? Type
----------------------------- -------- --------------------
DBID
NOT NULL NUMBER
TS#
NUMBER
OBJ#
NOT NULL NUMBER
DATAOBJ#
NOT NULL NUMBER
OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT NULL VARCHAR2(30)
SUBOBJECT_NAME
VARCHAR2(30)
OBJECT_TYPE
VARCHAR2(18)
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
PARTITION_TYPE
VARCHAR2(8)
DBA_HIST_SERVICE_NAME: Service Names
iSelfSchooling-SQL> desc DBA_HIST_SERVICE_NAME;
Name
Null? Type
----------------------------- -------- --------------------
DBID
NOT NULL NUMBER
SERVICE_NAME_HASH
NOT NULL NUMBER
SERVICE_NAME
NOT NULL VARCHAR2(64)
DBA_HIST_SERVICE_STAT: Historical Service Statistics
iSelfSchooling-SQL> desc DBA_HIST_SERVICE_STAT;
Name
Null?
Type
----------------------------- -------- --------------------
SNAP_ID
NUMBER
DBID
NUMBER
INSTANCE_NUMBER
NUMBER
SERVICE_NAME_HASH
NUMBER
SERVICE_NAME
VARCHAR2(64)
STAT_ID
NUMBER
STAT_NAME
VARCHAR2(64)
VALUE
NUMBER
DBA_HIST_SERVICE_WAIT_CLASS: Historical Service Wait Class Statistics
iSelfSchooling-SQL> desc DBA_HIST_SERVICE_WAIT_CLASS;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NUMBER
DBID NUMBER
INSTANCE_NUMBER
NUMBER
SERVICE_NAME_HASH
NUMBER
SERVICE_NAME
VARCHAR2(64)
WAIT_CLASS_ID
NUMBER
WAIT_CLASS
VARCHAR2(64)
TOTAL_WAITS
NUMBER
TIME_WAITED
NUMBER
DBA_HIST_SESSMETRIC_HISTORY: System Metrics History
iSelfSchooling-SQL> desc DBA_HIST_SESSMETRIC_HISTORY;
Name
Null?
Type
----------------------------- -------- --------------------
SNAP_ID
NOT NULL NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
BEGIN_TIME
NOT NULL DATE
END_TIME
NOT NULL DATE
SESSID
NOT NULL NUMBER
SERIAL#
NOT NULL NUMBER
INTSIZE
NOT NULL NUMBER
GROUP_ID
NOT NULL NUMBER
METRIC_ID
NOT NULL NUMBER
METRIC_NAME
NOT NULL VARCHAR2(64)
VALUE
NOT NULL NUMBER
METRIC_UNIT
NOT NULL VARCHAR2(64)
DBA_HIST_SESS_TIME_STATS: CPU and I/O time for interesting (STREAMS)
sessions
iSelfSchooling-SQL> desc DBA_HIST_SESS_TIME_STATS;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NOT NULL NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
SESSION_TYPE
NOT NULL VARCHAR2(64)
MIN_LOGON_TIME
DATE
SUM_CPU_TIME
NUMBER
SUM_SYS_IO_WAIT
NUMBER
SUM_USER_IO_WAIT
NUMBER
DBA_HIST_SGA: SGA Historical Statistics Information
iSelfSchooling-SQL> desc DBA_HIST_SGA;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NOT
NULL NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
NAME
NOT NULL VARCHAR2(64)
VALUE
NOT NULL NUMBER
DBA_HIST_SGASTAT: SGA Pool Historical Statistics Information
iSelfSchooling-SQL> desc DBA_HIST_SGASTAT;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NUMBER
DBID
NUMBER
INSTANCE_NUMBER
NUMBER
NAME
VARCHAR2(64)
POOL
VARCHAR2(12)
BYTES
NUMBER
DBA_HIST_SGA_TARGET_ADVICE: SGA Target Advice History
iSelfSchooling-SQL> desc DBA_HIST_SGA_TARGET_ADVICE;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NOT NULL NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
SGA_SIZE
NOT NULL NUMBER
SGA_SIZE_FACTOR
NOT NULL NUMBER
ESTD_DB_TIME
NOT NULL NUMBER
ESTD_PHYSICAL_READS
NUMBER
DBA_HIST_SHARED_POOL_ADVICE: Shared Pool Advice History
iSelfSchooling-SQL> desc DBA_HIST_SHARED_POOL_ADVICE;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NOT NULL NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
SHARED_POOL_SIZE_FOR_ESTIMATE NOT NULL 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
DBA_HIST_SNAPSHOT: Snapshot Information
iSelfSchooling-SQL> desc DBA_HIST_SNAPSHOT;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NOT NULL NUMBER
DBID
NOT
NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
STARTUP_TIME
NOT NULL TIMESTAMP(3)
BEGIN_INTERVAL_TIME
NOT NULL TIMESTAMP(3)
END_INTERVAL_TIME
NOT NULL TIMESTAMP(3)
SNAP_LEVEL NUMBER
ERROR_COUNT
NUMBER
DBA_HIST_SNAP_ERROR: Snapshot Error Information
iSelfSchooling-SQL> desc DBA_HIST_SNAP_ERROR;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NOT NULL NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
TABLE_NAME
NOT NULL VARCHAR2(30)
ERROR_NUMBER
NOT NULL NUMBER
|