试题详情
- 单项选择题 Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation ofperformance. 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
- E
关注下方微信公众号,在线模考后查看
热门试题
- 以下对于事务的叙述,比较全面的是()
- The ORDERS table ha
- Given: Whichcode,in
- You have
- Consider the&e
- Which of
- You are
- Which two̳
- What does the FORCE
- The TRANS_SUMM
- 如何强制执行日志切换()
- You work
- 以下哪类表空间中不能建立数据对象(表,索
- You issue&ensp
- oracle系统进程主要有哪些?
- You want to enable a
- Managementhasaskedyo
- You work
- Which two statements
- Examinethestructurei