Snapshot Management
Oracle 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 Snapshot Interval: modify_snapshot_settings
How to Change Oracle AWR Snapshot Interval to 30 Minutes using dbms_workload_repository.modify_snapshot_settings Purpose The Oracle Database Automatic Workload Repository (AWR) collects and stores performance statistics to help database administrators monitor and analyze database performance over time. The code …
Read MoreOracle AWR Snapshots: Query dba_hist_snapshot
Sep 22, 2025 / · 6 min read · Oracle Database AWR Performance Tuning SQL Scripts Database Monitoring DBA Tasks Snapshot Management Performance Analysis dba_hist_snapshot ·Understanding Oracle AWR Snapshot Display The Oracle Automatic Workload Repository (AWR) is a performance diagnostic tool that collects, processes, and stores database statistics automatically. Displaying a list of available snapshots is essential for database administrators who need to generate AWR reports, analyze …
Read MoreOracle Statspack sppurge: Snapshot Purge Script Guide
Sep 2, 2025 / · 4 min read · oracle-database statspack performance monitoring database administration snapshot management storage optimization dba scripts oracle tuning ·Oracle Database Statspack Snapshot Purge Script: Complete Guide to sppurge Administration The Oracle Database @?/rdbms/admin/sppurge; command is a critical administrative script used to delete old Statspack snapshots and manage storage space in the PERFSTAT schema. This comprehensive guide explores the purpose, …
Read More