Scripts

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 …

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 …

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 …

Oracle AWR Report Generation Using awrrpt.sql Script Purpose Where awrddrpt.sql compares two time periods and awrsqrpt.sql looks at one SQL statement, awrrpt.sql gives the general view. It builds a report of the statistics held between two snapshot IDs on the local database instance. The report can be HTML or text. The …

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 …

Oracle Statspack Automation: Scheduling Hourly Database Performance Snapshots Oracle Statspack automation provides database administrators with continuous performance monitoring capabilities through scheduled snapshot collection. The spauto.sql script enables automated hourly snapshots that capture essential database …

How to Uninstall Oracle Statspack Using the spdrop Script - Complete Guide Oracle Statspack uninstallation is accomplished using the @?/rdbms/admin/spdrop command, which completely removes the Statspack performance monitoring framework from your Oracle database. This command removes all associated objects including the …

Oracle Database Statspack Installation Guide - Complete Setup and Configuration Purpose Statspack is a snapshot-based way to see what an Oracle database did between two points in time. AWR is the better-known alternative, and the license position differs. Oracle's Licensing Information guide lists the Automatic …

How to List Oracle Statspack Snapshots with SQL Query This Oracle Database query provides a simple way to view all Statspack snapshots stored in your database. Statspack is Oracle's built-in performance monitoring tool that captures database statistics at regular intervals, helping database administrators analyze …

Oracle Database Statspack spreport.sql Script: Complete Performance Tuning Guide Statspack is the free, lightweight cousin of AWR, and @?/rdbms/admin/spreport.sql is the script that turns its stored snapshots into a readable report. It calculates instance activity between two snapshots, which helps you find bottlenecks …