Automatic Shared Memory Management is disabled for one of your database instances.Some SQL statements perform poorly due
Posted: Sun Jun 11, 2023 3:55 pm
Automatic Shared Memory Management is disabled for one of your database instances.Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.What would be your next step?
A. Run the SQL Access Advisor.
B. Run the Memory Advisor for the shared pool.
C. Run the SQL Tuning Advisor.
D. Run the Memory Advisor for the Program Global Area. E. Run the Memory Advisor for the System Global Area.
A. Run the SQL Access Advisor.
B. Run the Memory Advisor for the shared pool.
C. Run the SQL Tuning Advisor.
D. Run the Memory Advisor for the Program Global Area. E. Run the Memory Advisor for the System Global Area.