[Home] [Help]
[Dependency Information]
VIEW: SYS.DBA_HIST_SNAPSHOT
Object Details
Object Name: | DBA_HIST_SNAPSHOT |
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Snapshot Information
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
SNAP_ID |
NUMBER |
|
Yes |
|
DBID |
NUMBER |
|
Yes |
|
INSTANCE_NUMBER |
NUMBER |
|
Yes |
|
STARTUP_TIME |
TIMESTAMP(3) |
(11) |
Yes |
|
BEGIN_INTERVAL_TIME |
TIMESTAMP(3) |
(11) |
Yes |
|
END_INTERVAL_TIME |
TIMESTAMP(3) |
(11) |
Yes |
|
FLUSH_ELAPSED |
INTERVAL DAY(5) TO SECOND(1) |
(11) |
|
|
SNAP_LEVEL |
NUMBER |
|
|
|
ERROR_COUNT |
NUMBER |
|
|
|
SNAP_FLAG |
NUMBER |
|
|
|
SNAP_TIMEZONE |
INTERVAL DAY(0) TO SECOND(0) |
(11) |
|
|
CON_ID |
NUMBER |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT SNAP_ID
, DBID
, INSTANCE_NUMBER
, STARTUP_TIME
, BEGIN_INTERVAL_TIME
, END_INTERVAL_TIME
, FLUSH_ELAPSED
, SNAP_LEVEL
, ERROR_COUNT
, SNAP_FLAG
, SNAP_TIMEZONE
, CON_ID
FROM SYS.DBA_HIST_SNAPSHOT;
Dependencies
[top of page]
SYS.DBA_HIST_SNAPSHOT references the following:
-
SYS
-
INT$DBA_HIST_SNAPSHOT
SYS.DBA_HIST_SNAPSHOT is referenced by following:
-
PUBLIC
-
DBA_HIST_SNAPSHOT
-
SYS
-
DBMS_FEATURE_AWR
- show dependent code
-
DBMS_MANAGEMENT_PACKS
- show dependent code
-
DBMS_PERF
- show dependent code
-
DBMS_REPORT
- show dependent code
-
DBMS_SQLTCB_INTERNAL
- show dependent code
-
DBMS_SQLTUNE
- show dependent code
-
DBMS_SQLTUNE_INTERNAL
- show dependent code
-
DBMS_SQLTUNE_UTIL2
- show dependent code
-
DBMS_SWRF_REPORT_INTERNAL
- show dependent code
-
DBMS_WORKLOAD_CAPTURE
- show dependent code
-
DBMS_WORKLOAD_REPLAY
- show dependent code
-
DBMS_WORKLOAD_REPOSITORY
- show dependent code
-
DBMS_WRR_INTERNAL
- show dependent code
-
INT$DBA_HIST_ACT_SESS_HISTORY
-
INT$DBA_HIST_APPLY_SUMMARY
-
INT$DBA_HIST_ASM_BAD_DISK
-
INT$DBA_HIST_BG_EVENT_SUMMARY
-
INT$DBA_HIST_BUFFERED_QUEUES
-
INT$DBA_HIST_BUFFER_POOL_STAT
-
INT$DBA_HIST_BUF_SUBSCRIBERS
-
INT$DBA_HIST_CAPTURE
-
INT$DBA_HIST_CELL_DB
-
INT$DBA_HIST_CELL_DISK_SUMMARY
-
INT$DBA_HIST_CELL_GLBL_SUMMARY
-
INT$DBA_HIST_CELL_GLOBAL
-
INT$DBA_HIST_CELL_IOREASON
-
INT$DBA_HIST_CELL_OPEN_ALERTS
-
INT$DBA_HIST_CLUSTER_INTERCON
-
INT$DBA_HIST_COMP_IOSTAT
-
INT$DBA_HIST_CR_BLOCK_SERVER
-
INT$DBA_HIST_CURR_BLK_SERVER
-
INT$DBA_HIST_DB_CACHE_ADVICE
-
INT$DBA_HIST_DISPATCHER
-
INT$DBA_HIST_DLM_MISC
-
INT$DBA_HIST_DYN_RE_STATS
-
INT$DBA_HIST_ENQUEUE_STAT
-
INT$DBA_HIST_EVENT_HISTOGRAM
-
INT$DBA_HIST_FILESTATXS
-
INT$DBA_HIST_FM_HISTORY
-
INT$DBA_HIST_IC_CLIENT_STATS
-
INT$DBA_HIST_IC_DEVICE_STATS
-
INT$DBA_HIST_IC_PINGS
-
INT$DBA_HIST_IC_TRANSFER
-
INT$DBA_HIST_IM_SEG_STAT
-
INT$DBA_HIST_INSTANCE_RECOVERY
-
INT$DBA_HIST_IOSTAT_DETAIL
-
INT$DBA_HIST_IOSTAT_FILETYPE
-
INT$DBA_HIST_IOSTAT_FUNCTION
-
INT$DBA_HIST_JAVA_POOL_ADVICE
-
INT$DBA_HIST_LATCH
-
INT$DBA_HIST_LATCH_CHILDREN
-
INT$DBA_HIST_LATCH_PARENT
-
INT$DBA_HIST_LAT_M_SUMMARY
-
INT$DBA_HIST_LIBRARYCACHE
-
INT$DBA_HIST_LOG
-
INT$DBA_HIST_MEMORY_RESIZE_OPS
-
INT$DBA_HIST_MEM_DYNAMIC_COMP
-
INT$DBA_HIST_MEM_TGT_ADVICE
-
INT$DBA_HIST_MTTR_TGT_ADVICE
-
INT$DBA_HIST_MUTEX_SLEEP
-
INT$DBA_HIST_MVPARAMETER
-
INT$DBA_HIST_OSSTAT
-
INT$DBA_HIST_PARAMETER
-
INT$DBA_HIST_PERSISTENT_QUEUES
-
INT$DBA_HIST_PERSISTENT_SUBS
-
INT$DBA_HIST_PERS_QMN_CACHE
-
INT$DBA_HIST_PGASTAT
-
INT$DBA_HIST_PGA_TARGET_ADVICE
-
INT$DBA_HIST_PMEM_SUMMARY
-
INT$DBA_HIST_REP_TBL_STATS
-
INT$DBA_HIST_REP_TXN_STATS
-
INT$DBA_HIST_RESOURCE_LIMIT
-
INT$DBA_HIST_ROWCACHE_SUMMARY
-
INT$DBA_HIST_RSRC_CON_GROUP
-
INT$DBA_HIST_RSRC_PLAN
-
INT$DBA_HIST_RULE_SET
-
INT$DBA_HIST_SEG_STAT
-
INT$DBA_HIST_SERVICE_STAT
-
INT$DBA_HIST_SESS_SGA_STATS
-
INT$DBA_HIST_SESS_TIME_STATS
-
INT$DBA_HIST_SGA
-
INT$DBA_HIST_SGASTAT
-
INT$DBA_HIST_SGA_TARGET_ADVICE
-
INT$DBA_HIST_SHRD_SVR_SUMMARY
-
INT$DBA_HIST_SM_HISTORY
-
INT$DBA_HIST_SPOOL_ADVICE
-
INT$DBA_HIST_SQLSTAT
-
INT$DBA_HIST_SQL_SUMMARY
-
INT$DBA_HIST_SQL_WA_HSTGRM
-
INT$DBA_HIST_STREAMS_APPLY_SUM
-
INT$DBA_HIST_STREAMS_CAPTURE
-
INT$DBA_HIST_STRPOOL_ADVICE
-
INT$DBA_HIST_SVC_WAIT_CLASS
-
INT$DBA_HIST_SYSMETRIC_HISTORY
-
INT$DBA_HIST_SYSMETRIC_SUMMARY
-
INT$DBA_HIST_SYSSTAT
-
INT$DBA_HIST_SYSTEM_EVENT
-
INT$DBA_HIST_SYS_TIME_MODEL
-
INT$DBA_HIST_TABLESPACE_STAT
-
INT$DBA_HIST_TBSPC_SPACE_USAGE
-
INT$DBA_HIST_TEMPSTATXS
-
INT$DBA_HIST_THREAD
-
INT$DBA_HIST_UNDOSTAT
-
INT$DBA_HIST_WAITSTAT
-
INT$DBA_HIST_WCM_HISTORY
-
PRVTEMX_CELL
- show dependent code
-
PRVT_AWRV_METADATA
-
PRVT_AWR_VIEWER
- show dependent code
-
PRVT_HDM
- show dependent code