AWR(Automatic Workload Repository)——比较报告的生成(2)!
来源:互联网 发布:电子密码锁编程 编辑:程序博客网 时间:2024/06/05 16:29
基线(Baseline):
在创建数据库比较报告时,通常选择两个时段的采样进行比较,而如果我们能够创建基于正常运行的数据库快照,在发生性能问题时,就可以将异常与正常情况进行比较,获得差异对比信息。有了基线之后,AWR报告之间的对比就会更加明确和有效。
SQL> exec dbms_workload_repository.create_baseline(start_snap_id=>90,end_snap_id=>95,baseline_name=>'baseline01');PL/SQL 过程已成功完成。SQL> select * from dba_hist_baseline; DBID BASELINE_ID BASELINE_NAM START_SNAP_ID START_SNAP_TIME END_SNAP_ID END_SNAP_TIME---------- ----------- ------------ ------------- ------------------------------ ----------- ------------------------------1293815896 1 baseline01 90 25-11月-11 02.17.22.241 上午 95 25-11月-11 07.00.39.847 上午SQL> exec dbms_workload_repository.drop_baseline(baseline_name=>'baseline01',cascade=>true);PL/SQL 过程已成功完成。SQL> select * from dba_hist_baseline;未选定行在删除的时候指定了cascade=>true,那么快照信息也会级联的被删除!就是说再次生成AWR报告的时候将会看不见90~95的快照信息了。
awrddrpt.sql脚本可以对同一个数据库两个时段进行比较,生成详细的对比报告,提供比较分析!
awrddrpi.sql脚本可以对不同的数据库两个时段进行比较,生成详细的对比报告,提供比较分析!
[oracle@linux awr]$ sqlplus / as sysdba @?/rdbms/admin/awrddrpt.sql --生成AWR对比报告。SQL*Plus: Release 10.2.0.4.0 - Production on 星期六 11月 26 01:02:30 2011Copyright (c) 1982, 2007, Oracle. All Rights Reserved.连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsCurrent Instance~~~~~~~~~~~~~~~~ DB Id DB Id DB Name Inst Num Inst Num Instance----------- ----------- ------------ -------- -------- ------------ 1293815896 1293815896 ORCL 1 1 orclSpecify the Report Type~~~~~~~~~~~~~~~~~~~~~~~Would you like an HTML report, or a plain text report?Enter 'html' for an HTML report, or 'text' for plain textDefaults to 'html'输入 report_type 的值: --选择html默认值。Type Specified: htmlInstances in this Workload Repository schema~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id Inst Num DB Name Instance Host------------ -------- ------------ ------------ ------------* 1293815896 1 ORCL orcl linuxDatabase Id and Instance Number for the First Pair of Snapshots~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Using 1293815896 for Database Id for the first pair of snapshotsUsing 1 for Instance Number for the first pair of snapshotsSpecify the number of days of snapshots to choose from~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Entering the number of days (n) will result in the most recent(n) days of snapshots being listed. Pressing <return> withoutspecifying a number lists all completed snapshots.输入 num_days 的值: 2 --最近2天。Listing the last 2 days of Completed Snapshots SnapInstance DB Name Snap Id Snap Started Level------------ ------------ --------- ------------------ -----orcl ORCL 90 25 11月 2011 02:17 1 91 25 11月 2011 03:00 1 92 25 11月 2011 04:00 1 93 25 11月 2011 05:00 1 94 25 11月 2011 06:00 1 95 25 11月 2011 07:00 1 96 25 11月 2011 08:00 1 97 25 11月 2011 23:59 1 98 26 11月 2011 01:00 1Specify the First Pair of Begin and End Snapshot Ids~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~输入 begin_snap 的值: 91First Begin Snapshot Id specified: 91 --第一个开始采样值。输入 end_snap 的值: 92First End Snapshot Id specified: 92 --第一个结束采样值。Instances in this Workload Repository schema~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id Inst Num DB Name Instance Host------------ -------- ------------ ------------ ------------* 1293815896 1 ORCL orcl linuxDatabase Id and Instance Number for the Second Pair of Snapshots~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Using 1293815896 for Database Id for the second pair of snapshotsUsing 1 for Instance Number for the second pair of snapshotsSpecify the number of days of snapshots to choose from~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Entering the number of days (n) will result in the most recent(n) days of snapshots being listed. Pressing <return> withoutspecifying a number lists all completed snapshots.输入 num_days2 的值: 2 --还是最近2天。Listing the last 2 days of Completed Snapshots SnapInstance DB Name Snap Id Snap Started Level------------ ------------ --------- ------------------ -----orcl ORCL 90 25 11月 2011 02:17 1 91 25 11月 2011 03:00 1 92 25 11月 2011 04:00 1 93 25 11月 2011 05:00 1 94 25 11月 2011 06:00 1 95 25 11月 2011 07:00 1 96 25 11月 2011 08:00 1 97 25 11月 2011 23:59 1 98 26 11月 2011 01:00 1Specify the Second Pair of Begin and End Snapshot Ids~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~输入 begin_snap2 的值: 92 --第二个开始采样值。Second Begin Snapshot Id specified: 92输入 end_snap2 的值: 93 --第二个结束采样值。Second End Snapshot Id specified: 93Specify the Report Name~~~~~~~~~~~~~~~~~~~~~~~The default report file name is awrdiff_1_91_1_92.html To use this name,press <return> to continue, otherwise enter an alternative.输入 report_name 的值: --默认值。Using the report name awrdiff_1_91_1_92.html... ...... ...... ...P><P><P><P><P></BODY></HTML>Report written to awrdiff_1_91_1_92.html
- AWR(Automatic Workload Repository)——比较报告的生成(2)!
- AWR (Automatic Workload Repository)
- AWR(Automatic Workload Repository)——概述(1)!
- AWR(Automatic Workload Repository)——分析(3)!
- AWR(Automatic Workload Repository)——分析(4)!
- Oracle AWR(Automatic Workload Repository) 说明
- Oracle AWR(Automatic Workload Repository) 说明
- AWR - Automatic Workload Repository
- AWR(Automatic Workload Repository)
- 自动工作负载库(Automatic Workload Repository,AWR)
- Oracle AWR(Automatic Workload Repository) 说明 --转自tianlesoftware
- Oracle AWR(Automatic Workload Repository) 简单说明
- 自动工作负载库(Automatic Workload Repository,AWR)
- 自动工作负载库(Automatic Workload Repository,AWR)
- Oracle AWR(Automatic Workload Repository)(转自tianlesoftware的博客)
- AWR (Automatic Workload Repository) Report
- Oracle AWR (Automatic Workload Repository)
- Oracle AWR(Automatic workload repository)
- 统计工程里的代码行数
- 在xcode 4.2.1中通过RHManagedObject 和RHManagedObjectContextManager 来简化 CoreData的处理
- 《Effective C++》小结
- oracle 根据值找字段
- SVN地址
- AWR(Automatic Workload Repository)——比较报告的生成(2)!
- 解决RHEL、CentOS无法更新到最新版本的PHP的问题
- Entity简介
- 找不到请求的 .Net Framework Data Provider。可能没有安装.
- oracle 分页效率sql
- mas2.0 java 短信/彩信开发接口
- SVN出错问题汇总
- Weblogic 10.3 insallment and Cluster setup - 1
- php APC模块