awr_evtrends.sql

Query to display "trends" for specific wait-events captured in the AWR repository, and display summarized totals daily and hourly as a ratio using the RATIO_FOR_REPORT analytic function.

The intent is to find the readings with the greatest deviation from the average value, as these are likely to be "periods of interest" for further, more detailed research.