awr_evtrends.sql

  • Version
  • Download 496
  • File Size 17.47 KB
  • File Count 1
  • Create Date April 17, 2016
  • Last Updated April 17, 2016

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.