Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation of performance.
What would be your next step to improve performance?
A.
Run the SQL Access Advisor
B.
Run the memory Advisor for the SGA
C.
Run the memory Advisor for the PGA
D.
Run the memory advisor for the shared pool
E.
Run the memory advisor for the buffer cache
The ANSWER IS D
D. Run the memory advisor for the shared pool
similar question:
Automatic Shared Memory Management is ENABLED for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation of performance.
Which action generates recommendations to overcome the perfrmance issues?
a Run the memory advisor for the library cache
b Run the memory advisor for the buffer cache
c Run the memory advisor for the PGA
d Run the memory advisor for the SGA
correct: D