Workload Repository
How to Remove an Oracle AWR Baseline Using DROP_BASELINE
Sep 30, 2025 / · 4 min read · Oracle AWR Database Performance DBA PL/SQL Performance Tuning Baseline Management Workload Repository ·How to Remove an Oracle AWR Baseline Using DROP_BASELINE Purpose The DROP_BASELINE procedure removes a previously-defined AWR (Automatic Workload Repository) baseline from an Oracle database. This command is essential for database administrators who need to conserve storage space by deleting unused or outdated …
Read MoreOracle AWR: Change Retention Period to 14 Days
How to Change Oracle AWR Retention Period to 14 Days using dbms_workload_repository.modify_snapshot_settings Purpose The Oracle code changes the Automatic Workload Repository (AWR) retention period from the default 8 days to 14 days (two weeks). This allows database administrators to store performance snapshots for a …
Read MoreOracle AWR Interval and Retention: DBA_HIST_WR_CONTROL
Sep 24, 2025 / · 6 min read · Oracle Database AWR Performance Tuning Database Administration SQL Scripts Monitoring Workload Repository DBA dba_hist_wr_control ·How to Check Oracle AWR Snapshot Interval and Retention Settings using table dba_hist_wr_control Purpose The Oracle Database Automatic Workload Repository (AWR) is a critical component for performance monitoring and database tuning that automatically collects and stores performance statistics at regular intervals. This …
Read More