Prev Question
Next Question

Which is a capability that Active Session History (ASH) reports enable you to perform?

A. Compare database performance between two periods of time, and resolve performance degradation
that may happen from one time period to another.

B. Analyze transient performance problems with the database that are short-lived and do not appear in the
ADDM analysis.

C. Optimize the performance of data access paths by creating the proper set of materialized views,
materialized view logs, and indexes for a given workload.

D. Analyze transient performance problems that have happened in the database since it has been started.

Explanation: The Active Session History (ASH) reports enable you to analyze transient performance
problems with the database that are short-lived and do not appear in the ADDM analysis.
Reference: http://docs.oracle.com/cd/B19306_01/server.102/b28051/tdppt_method.htm#TDPPT017

Prev Question
Next Question

Leave a Reply

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