DBA History Views

The Oracle views prefixed with DBA_HIST_* belong to the Automatic Workload Repository (AWR), a feature designed for performance tuning and diagnostics in the database. These views offer historical performance, configuration and miscellaneous data collected by the AWR at regular intervals (hourly by default). They are essential for analyzing database performance trends, identifying issues, and optimizing resource utilization.

It’s common to need historical information without knowing if a specific DBA_HIST_* view exists for your query. For example, did you know there’s historical data on global cache service processes or snapshot errors? Who knew, right?    But finding the right one in the Oracle documentation can be a challenge since there doesnt seem to be a readily availble list. To save time, here’s a complete list of these views as of Oracle 23ai.

DBA_HIST_ACTIVE_SESS_HISTORY

DBA_HIST_APPLY_SUMMARY

DBA_HIST_ASH_SNAPSHOT

DBA_HIST_BASELINE

DBA_HIST_BASELINE_DETAILS

DBA_HIST_BASELINE_METADATA

DBA_HIST_BASELINE_TEMPLATE

DBA_HIST_BG_EVENT_SUMMARY

DBA_HIST_BUFFER_POOL_STAT

DBA_HIST_BUFFERED_QUEUES

DBA_HIST_BUFFERED_SUBSCRIBERS

DBA_HIST_CAPTURE

DBA_HIST_CHANNEL_WAITS

DBA_HIST_CLUSTER_INTERCON

DBA_HIST_COLORED_SQL

DBA_HIST_COMP_IOSTAT

DBA_HIST_CON_SYS_TIME_MODEL

DBA_HIST_CON_SYSMETRIC_HIST

DBA_HIST_CON_SYSMETRIC_SUMM

DBA_HIST_CON_SYSSTAT

DBA_HIST_CON_SYSTEM_EVENT

DBA_HIST_CR_BLOCK_SERVER

DBA_HIST_CURRENT_BLOCK_SERVER

DBA_HIST_DATABASE_INSTANCE

DBA_HIST_DATAFILE

DBA_HIST_DB_CACHE_ADVICE

DBA_HIST_DISPATCHER

DBA_HIST_DLM_MISC

DBA_HIST_DYN_REMASTER_STATS

DBA_HIST_ENQUEUE_STAT

DBA_HIST_EVENT_HISTOGRAM

DBA_HIST_EVENT_NAME

DBA_HIST_FILEMETRIC_HISTORY

DBA_HIST_FILESTATXS

DBA_HIST_IC_CLIENT_STATS

DBA_HIST_IC_DEVICE_STATS

DBA_HIST_IM_SEG_STAT

DBA_HIST_IM_SEG_STAT_OBJ

DBA_HIST_INST_CACHE_TRANSFER

DBA_HIST_INSTANCE_RECOVERY

DBA_HIST_INTERCONNECT_PINGS

DBA_HIST_IOSTAT_DETAIL

DBA_HIST_IOSTAT_FILETYPE

DBA_HIST_IOSTAT_FILETYPE_NAME

DBA_HIST_IOSTAT_FUNCTION

DBA_HIST_IOSTAT_FUNCTION_NAME

DBA_HIST_JAVA_POOL_ADVICE

DBA_HIST_LATCH

DBA_HIST_LATCH_CHILDREN

DBA_HIST_LATCH_MISSES_SUMMARY

DBA_HIST_LATCH_NAME

DBA_HIST_LATCH_PARENT

DBA_HIST_LIBRARYCACHE

DBA_HIST_LOG

DBA_HIST_MEM_DYNAMIC_COMP

DBA_HIST_MEMORY_RESIZE_OPS

DBA_HIST_MEMORY_TARGET_ADVICE

DBA_HIST_METRIC_NAME

DBA_HIST_MTTR_TARGET_ADVICE

DBA_HIST_MUTEX_SLEEP

DBA_HIST_OPTIMIZER_ENV

DBA_HIST_OPTIMIZER_ENV_DETAILS

DBA_HIST_OSSTAT

DBA_HIST_OSSTAT_NAME

DBA_HIST_PARAMETER

DBA_HIST_PARAMETER_NAME

DBA_HIST_PDB_IN_SNAP

DBA_HIST_PDB_INSTANCE

DBA_HIST_PERSISTENT_QMN_CACHE

DBA_HIST_PERSISTENT_QUEUES

DBA_HIST_PERSISTENT_SUBS

DBA_HIST_PGA_TARGET_ADVICE

DBA_HIST_PGASTAT

DBA_HIST_PLAN_OPERATION_NAME

DBA_HIST_PLAN_OPTION_NAME

DBA_HIST_PROCESS_MEM_SUMMARY

DBA_HIST_PROCESS_WAITTIME

DBA_HIST_RECOVERY_PROGRESS

DBA_HIST_REPLICATION_TBL_STATS

DBA_HIST_REPLICATION_TXN_STATS

DBA_HIST_REPORTS

DBA_HIST_REPORTS_CONTROL

DBA_HIST_REPORTS_DETAILS

DBA_HIST_REPORTS_TIMEBANDS

DBA_HIST_RESOURCE_LIMIT

DBA_HIST_ROWCACHE_SUMMARY

DBA_HIST_RSRC_CONSUMER_GROUP

DBA_HIST_RSRC_METRIC

DBA_HIST_RSRC_PDB_METRIC

DBA_HIST_RSRC_PLAN

DBA_HIST_RULE_SET

DBA_HIST_SAGAS

DBA_HIST_SEG_STAT

DBA_HIST_SEG_STAT_OBJ

DBA_HIST_SERVICE_NAME

DBA_HIST_SERVICE_STAT

DBA_HIST_SERVICE_WAIT_CLASS

DBA_HIST_SESS_SGA_STATS

DBA_HIST_SESS_TIME_STATS

DBA_HIST_SESSMETRIC_HISTORY

DBA_HIST_SGA

DBA_HIST_SGA_TARGET_ADVICE

DBA_HIST_SGASTAT

DBA_HIST_SHARED_POOL_ADVICE

DBA_HIST_SHARED_SERVER_SUMMARY

DBA_HIST_SNAP_ERROR

DBA_HIST_SNAPSHOT

DBA_HIST_SQL_BIND_METADATA

DBA_HIST_SQL_PLAN

DBA_HIST_SQL_SUMMARY

DBA_HIST_SQL_WORKAREA_HSTGRM

DBA_HIST_SQLBIND

DBA_HIST_SQLCOMMAND_NAME

DBA_HIST_SQLSTAT

DBA_HIST_SQLTEXT

DBA_HIST_STAT_NAME

DBA_HIST_STREAMS_APPLY_SUM

DBA_HIST_STREAMS_CAPTURE

DBA_HIST_STREAMS_POOL_ADVICE

DBA_HIST_SYS_TIME_MODEL

DBA_HIST_SYSMETRIC_HISTORY

DBA_HIST_SYSMETRIC_SUMMARY

DBA_HIST_SYSSTAT

DBA_HIST_SYSTEM_EVENT

DBA_HIST_TABLESPACE

DBA_HIST_TABLESPACE_STAT

DBA_HIST_TBSPC_SPACE_USAGE

DBA_HIST_TEMPFILE

DBA_HIST_TEMPSTATXS

DBA_HIST_THREAD

DBA_HIST_TOPLEVELCALL_NAME

DBA_HIST_UNDOSTAT

DBA_HIST_WAITCLASSMET_HISTORY

DBA_HIST_WAITSTAT

DBA_HIST_WR_CONTROL

DBA_HIST_WR_SETTING

Published 

29th November 2024