Download is available until [expire_date]
  • Version
  • Download 700
  • File Size 17.47 KB
  • File Count 1
  • Create Date April 17, 2016
  • Last Updated April 17, 2016


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.

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.