What would you suggest to analyze this performance problem for the user?

The Automatic Workload Repository (AWR) snapshot interval is set to 1 hour. A user of your
database notifies you that the system was slow between 10:00 PM and 10:10 PM, but the
Automatic Database Diagnostic Management (ADDM) analysis for the time period between 10:00
PM and 11:00 PM does not show this performance problem.What would you suggest to analyze
this performance problem for the user?

The Automatic Workload Repository (AWR) snapshot interval is set to 1 hour. A user of your
database notifies you that the system was slow between 10:00 PM and 10:10 PM, but the
Automatic Database Diagnostic Management (ADDM) analysis for the time period between 10:00
PM and 11:00 PM does not show this performance problem.What would you suggest to analyze
this performance problem for the user?

A.
SQL Tuning Advisor

B.
SQL Performance Analyzer

C.
Active Session History report

D.
AWR Compare Periods report



Leave a Reply 1

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


L. Zhu

L. Zhu

ASH report for short period perf issue

C