Dbms_job

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 …

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 …