试题详情
- 单项选择题The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings, workload profile,and statistics to diagnose the possible causes of the performance degradation?()
A、by using the SQL access advisor
B、by using the Automatic Workload Repository report
C、by running the Automatic Database Diagnostic Monitor (ADDM)
D、by using the Automatic Workload Repository Compare Period report
E、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view
- D
关注下方微信公众号,在线模考后查看
热门试题
- You work
- A customerQ
- Given: Whichthreear
- You want
- The Automatic&
- Which two statements
- ()包含了一些潜在的由系统管理员如SYS
- Given: Whatistheres
- You are
- Which constraint can
- Which tasks
- Given: Underwhichth
- Which client request
- Which of the followi
- The customer
- ()是ORACLE最基本的逻辑存储单位。
- The database is run
- Which clause should
- Youwanttoperformthef
- You used