QUESTION 56 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
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
Correct Answer: D
自动共享内存管理是禁用的,你发现sql的重复解析影响数据库的性能,应该使 用哪种指导提高性能?
A: 错误,sql访问指导,会在是否应创建索引,分区,物化视图方面给出建议,提高sql执行性能, 与sql解析无关.
B: 错误,禁用自动共享内存管理时,无法使用SGA内存指导.
C: 错误,PGA与sql解析无关,不应运行PGA内存指导.
D: 正确,sql解析与shared pool相关. E: 错误,buffer cache一般与修改和访问数据,逻辑读或物理读相关,与sql解析无关