DBAHIST
DBAHIST is a term commonly used to refer to Oracle Database’s historical performance data, exposed through a family of data dictionary views prefixed with DBA_HIST_. It represents the stored history of performance-related metrics gathered by the Automatic Workload Repository (AWR) and related components, rather than a single table or view. The DBA_HIST_ views provide a historical record of system and session activity that enables trend analysis, bottleneck identification, and capacity planning.
The DBA_HIST family typically includes views such as DBA_HIST_SNAPSHOT, which contains time-stamped snapshots of the database
Access to DBA_HIST views is available when the Oracle Diagnostic Pack is licensed, and entry points are
DBAHIST enables retrospective analysis, performance forecasting, and capacity planning by providing historical context for performance metrics.
Oracle Database, Automatic Workload Repository (AWR), Active Session History (ASH), DBA views, V$ views.