Prev Question
Next Question

You determine that database performance is sub-optimal due to hard parsing statements. Automatic Shared
Memory Management (ASMM) is disabled for your database instance.
Which tool would you use to get advice on how to improve performance?

A.
Memory Advisor for the PGA

B.
SQL Access Advisor

C.
Memory Advisor for the shared pool

D.
SQL Tuning Advisor

Explanation:
http://docs.oracle.com/cd/E25178_01/server.1111/e10897/montune.htm#CHDGFCFJ

Prev Question
Next Question

Leave a Reply

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