Which tool would you consider using first to diagnose the cause of the performance degradation?

Your organization has purchased licenses for the Diagnostic Pack along with the Oracle Database
11g software.The application workload on your database is known to be stable between 10:00 PM
and midnight every night, but the performance on a particular Thursday was poor between 10:00
PM and 11:00 PM. Which tool would you consider using first to diagnose the cause of the
performance degradation?

Your organization has purchased licenses for the Diagnostic Pack along with the Oracle Database
11g software.The application workload on your database is known to be stable between 10:00 PM
and midnight every night, but the performance on a particular Thursday was poor between 10:00
PM and 11:00 PM. Which tool would you consider using first to diagnose the cause of the
performance degradation?

A.
Database Replay

B.
STATSPACK Report

C.
AWR Compare Report

D.
SQL Performance Analyzer



Leave a Reply 1

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


L. Zhu

L. Zhu

C is right