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
Parsing is the conversion of code written by programmers into something
executable, and it is a process which Oracle does on demand. By caching parsed
code in the shared pool so that it can be reused without reparsing, performance
can be greatly improved.
The answer is :
E.
Run the memory advisor for the buffer cache
but its green with D