Automatic Shared Memory Management is disabled for one of your database instances.Some SQL statements perform poorly due

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

Automatic Shared Memory Management is disabled for one of your database instances.Some SQL statements perform poorly due

Post by answerhappygod »

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply

Return to “Archived Questions & Answers”