ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 043-019

043-019

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-14 12:40:56 0 删除 编辑
19. The application workload on your database is same bwtween 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 (AWR) compare period report.
E. By analyzing the output of the v$ACTIVE_SESSION_HISTORY view.
答案:D
查看awr报告 选择开始快照 和结束快照之间数据库不要重启
While an AWR report shows AWR data between two snapshots (or two points in time), the AWR Compare Periods report shows the difference between two periods (or two AWR reports, which equates to four snapshots). Using the AWR Compare Periods report helps you to identify detailed performance attributes and configuration settings that differ between two time periods.(即可以对比两个不同时间段的AWR报告)
To generate an AWR Compare Periods report: @$ORACLE_HOME/rdbms/admin/awrddrpt.sql
Automatic Database Diagnostic Monitor (ADDM) ADDM 在创建每个AWR 快照之后自动运行。每次创建快照后,ADDM 都会分析与最后两个快照对应的时段。多数情况下,ADDM 会为检测到的问题提供建议解决方案,甚至可以量化这些建议案的
优势。ADDM分析的结果存放在AWR中。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718499/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 042-018
下一篇: 042-022
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    202864