OCP 1Z0 052 57

来源:互联网 发布:小组网络研修计划 编辑:程序博客网 时间:2024/05/01 11:15
57. 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. 
Answer: D

重复解析过多,说明shared pool不够
0 0
原创粉丝点击