试题详情
- 单项选择题 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
- D
关注下方微信公众号,在线模考后查看
热门试题
- Which two̳
- ou are in
- Examine the&en
- Which of
- EvaluatethesetwoSQLs
- Given: What is
- Given: String[]&ens
- Given: Whatisthere
- You have installed
- You installed Oracl
- Automatic data
- Which three activiti
- Which two statements
- You need to create a
- Which command&
- View the E
- User SCOTT&ens
- You are
- The STUDENT_GRADES
- The session&en