ExamQuestions.com

Register
Login
Oracle Database Administration II Exam Questions

Oracle

Oracle Database Administration II

25 / 80

Question 25:

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? 

Answer options:

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.