PERL SCRIPT TO GENERATE AWR REPORT TIME SERIES IN A GIVEN TIMEFRAME (Doc ID 2857522.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

This note provides a perl script to produce AWR report time series in a given time frame. It can be useful when the interested interval is very large and AWR extract generate a huge file not easy to manage. AWR time series is good trade-off between precision (information about sql in the AWR report is just a summary of all sql statistics stored in the workload repository) and time interval extent. In this sense it's a very useful for trend analysis especially when many statistics are involved and correlations between different statistics are required. Having the complete AWR time series provides the capability to manage data and trend analysis with regular expression awk perl and other command line tools.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.