How are performance baselines captured in Oracle Autonomous Database?

Performance baselines in Oracle Autonomous Database are captured through the automatic workload repository (AWR). AWR is a key feature that collects, processes, and maintains performance statistics for the database. It serves as a repository of various system performance metrics, which include active sessions, wait events, and resource usage over time. This allows database administrators and automated processes to analyze performance trends, pinpoint deviations from regular performance patterns, and understand the overall health of the database.

AWR comprehensively gathers data about workload characteristics, making it invaluable for performance analysis and tuning. It provides historical data that can be used for comparison against current performance, thus establishing baselines. The capabilities offered by AWR are integral to effectively monitoring and managing the performance of an Autonomous Database environment, leading to optimized operations and resource management.

While system logging, periodic user reports, and performance snapshots can provide useful insights into database behavior, they do not function as the primary means for establishing comprehensive performance baselines like AWR does.