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