Oracle AWR报告提取方法
来源:互联网 发布:js二级下拉菜单 编辑:程序博客网 时间:2024/06/11 01:49
本文旨在用来指导项目人员自行提取Oracle数据库的AWR报告.
1.当前连接实例的AWR报告提取:@?/rdbms/admin/awrrpt
2.RAC的其他实例AWR报告提取:@?/rdbms/admin/awrrpti
3.手工生成一个快照
1.当前连接实例的AWR报告提取:@?/rdbms/admin/awrrpt
SQL> @?/rdbms/admin/awrrpt//注意输入的@?/rdbms/admin/awrrpt 中间没有任何空格,需要在数据库服务器上Oracle用户登陆,sqlplus / as sysdba 进入SQL> 下执行.Current Instance~~~~~~~~~~~~~~~~ DB Id DB Name Inst Num Instance----------- ------------ -------- ------------ 857123342 JY 1 jy1Specify 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'Enter value for report_type: //注意这里直接回车即可,默认就是html格式的Type Specified: htmlInstances in this Workload Repository schema~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id Inst Num DB Name Instance Host------------ -------- ------------ ------------ ------------ 857123342 2 JY jy2 rac2-server* 857123342 1 JY jy1 rac1-serverUsing 857123342 for database IdUsing 1 for instance numberSpecify 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.Enter value for num_days: 1//注意这里根据实际需要选择几天的AWR报告,一般取最近的AWR报告选择1天即可Listing the last day's Completed Snapshots SnapInstance DB Name Snap Id Snap Started Level------------ ------------ --------- ------------------ -----jy1 JY 92 16 Oct 2014 07:32 1 93 16 Oct 2014 09:00 1 94 16 Oct 2014 10:00 1 95 16 Oct 2014 11:00 1Specify the Begin and End Snapshot Ids~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Enter value for begin_snap: 94Begin Snapshot Id specified: 94Enter value for end_snap: 95End Snapshot Id specified: 95//注意这里输入的begin_snap 和 end_snap都是根据上面具体时间点对应的实际Snap Id那一列决定的. 比如我要选 09:00 - 10:00的话,那起始就应该是93和94. Specify the Report Name~~~~~~~~~~~~~~~~~~~~~~~The default report file name is awrrpt_1_94_95.html. To use this name,press <return> to continue, otherwise enter an alternative.Enter value for report_name: //这里默认回车即可,名字会有一个默认值的。Using the report name awrrpt_1_94_95.html此处省略大量屏幕输出..End of Report</BODY></HTML>Report written to awrrpt_1_94_95.htmlSQL> !pwd/home/oracle
注:生成的报告文件发送给我即可,例如此处就是指awrrpt_1_94_95.html文件,代表的是2014年10月16日10点~11点这一小时的数据库实例jy1的工作负载报告。
2.RAC的其他实例AWR报告提取:@?/rdbms/admin/awrrpti
SQL> @?/rdbms/admin/awrrptiSpecify 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'Enter value for report_type: Type Specified: htmlInstances in this Workload Repository schema~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id Inst Num DB Name Instance Host------------ -------- ------------ ------------ ------------ 857123342 2 JY jy2 rac2-server* 857123342 1 JY jy1 rac1-serverEnter value for dbid: 857123342Using 857123342 for database IdEnter value for inst_num: 2Using 2 for instance numberSpecify 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.Enter value for num_days: Listing all Completed Snapshots SnapInstance DB Name Snap Id Snap Started Level------------ ------------ --------- ------------------ -----jy2 JY 91 14 Oct 2014 10:10 1 92 16 Oct 2014 07:32 1 93 16 Oct 2014 09:00 1 94 16 Oct 2014 10:00 1 95 16 Oct 2014 11:00 1 Specify the Begin and End Snapshot Ids~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Enter value for begin_snap: 94Begin Snapshot Id specified: 94Enter value for end_snap: 95 End Snapshot Id specified: 95 Specify the Report Name~~~~~~~~~~~~~~~~~~~~~~~The default report file name is awrrpt_2_94_95.html. To use this name,press <return> to continue, otherwise enter an alternative.Enter value for report_name: Using the report name awrrpt_2_94_95.html此处省略大量屏幕输出..End of Report</BODY></HTML>Report written to awrrpt_2_94_95.html
3.手工生成一个快照:
exec dbms_workload_repository.create_snapshot();
SQL> exec dbms_workload_repository.create_snapshot();PL/SQL procedure successfully completed.
0 0
- Oracle AWR报告提取方法
- [Oracle] 分析AWR报告的方法
- 获取Oracle数据库awr报告方法
- oracle手工生成AWR报告方法
- oracle手工生成AWR报告方法记录
- oracle手工生成AWR报告方法记录
- oracle手工生成AWR报告方法记录
- oracle AWR性能监控报告生成方法
- oracle AWR性能监控报告生成方法
- oracle用dbms_workload_repository取AWR报告方法
- Oracle性能awr报告
- oracle的AWR报告
- ORACLE 抓取AWR报告
- Oracle AWR 报告详解
- Oracle AWR报告生成
- Oracle生成awr报告
- oracle AWR 报告 中文版
- oracle AWR报告原文件
- stm32中定时器中断的套路
- 【FRDM-KW41Z学习笔记】FRDM-KW41Z开发板入门
- Spring mvc <mvc:resources ***/> 作用
- zookeeper实现原理
- 用双缓存机制异步加载图片
- Oracle AWR报告提取方法
- MySql 1045 access denied for user 'root'@'localhost' using password yes错误解决方法
- spark厦大---Word2Vec--spark.ml
- 浅谈C#中virtual和abstract的区别
- 生成器 Generators
- Scala匿名函数语法
- 二五、vue仿百度搜索框
- MySQL ibdata1文件迁移
- 第5章 定时器Timer