Performance Advisories
Performance Advisories provide clear, explicit description of performance degradations affecting the database instance. Developed by Oracle performance tuning experts, these advisories:
Detect and diagnose performance degradations and provide steps to resolve them
Incorporate wait event analysis to focus only on significant issues affecting database performance
Use fuzzy evaluation techniques to combine relevant metrics and convey the appropriate priority of each issue relative to the database workload and to other problems evident within the specified timeframe
Provide clear and detailed explanations of performance degradations offering just-in-time education, and extensive background tuning information to assist DBAs in solving the problem at hand and in avoiding similar problems in the future
Advisories are presented in either a default ordered and categorized tuning plan or as an action plan that lists first the issues impacting database performance the most.
Also presented are any significant deviations in database workload and resource service times that may indicate performance anomalies that may merit further review or investigation.
Advisories are evaluated at 15 minute (optional), 1 hour and 6 hour intervals and considers database performance averages over the duration of the interval. Single degradation incidents that last for 15 minutes or less will show a greater priority in a 15 minute period than they might in a 6 hour interval. Use of three evaluation intervals balances the desire to identify single incident short duration degradations with the cost of repository storage. Frequent or chronic degradations will be evident in any of the intervals. Deviation advisories are evaluated at only 1 and 6 hour intervals.
Note: Advisory report exclude activity occurring outside of 15 minute intervals not completely contained within the timeframe. For example, if the report timeframe starts at 12:03 PM and ends at 1:03 PM, then activity occurring during the interval 12:00 PM – 12:15 PM would not be included.