A script that automates the generation of multiple consecutive Oracle AWR reports – useful for profiling database performance across time without manual intervention.
Tag: oracle scripts
Querying DBA_HIST_SNAPSHOT and DBA_HIST_SYSSTAT
Getting elapsed seconds between Oracle AWR snapshots is harder than it should be. Here's the correct approach to querying DBA_HIST_SNAPSHOT and joining it to DBA_HIST_SYSSTAT.
