AWR Reports
来源:互联网 发布:学c4d 知乎 编辑:程序博客网 时间:2024/04/30 12:04
A little thought for those who use OEM to generate AWR reports – if you generate the standard HTML form and then try posting it into (say) the OTN database forum when you want some help interpreting it, it won’t look very readable (even if you do remember to put the right tags before and after to reproduce it in fixed font).
So it’s a good idea to know how to produce the text format – which is what I do most of the time (especially since I often end up with a simple telnet or putty session into a client server). Take a look at $ORACLEHOME/rdbms/admin for all the scripts starting with “awr” – there’s quite a lot of them, and the number keeps growing. Apart from finding a script that will give you the standard AWR report in a good old-fashioned text format, you may that newer versions of Oracle include a few useful variations on the theme.
Here’s a list from the 11.2.0.2 home ($ORACLE_HOME/rdbms/admin) with (mostly) the one-line description from the start of file. I’ve put the most useful ones in the first list:
awrrpt.sql -- basic AWR report
awrsqrpt.sql -- Standard SQL statement Report
awrddrpt.sql -- Period diff on current instance
awrrpti.sql -- Workload Repository Report Instance (RAC)
awrgrpt.sql -- AWR Global Report (RAC)
awrgdrpt.sql -- AWR Global Diff Report (RAC)
awrinfo.sql -- Script to output general AWR information
For most people the awrrpt.sql and awrsqrpt.sql are likely to be sufficient, but the “difference between two periods” can be very useful – especially if you do things like regularly forcing an extra snapshot at the start and end of the overnight batch so that you can (when necessary) find the most significant differences in behaviour between the batch runs on two different nights.
If you get into the ‘RAC difference report’ you’ll need a very wide page – and very good eyesight !
There are also a lot of “infrastructure and support” bits – some of the “input” files give you some nice ideas about how you can write your own code to do little jobs like: “run the most recent AWR report automatically”:
awrblmig.sql -- AWR Baseline Migrate
awrload.sql -- AWR LOAD: load awr from dump file
awrextr.sql -- AWR Extract
awrddinp.sql -- Get inputs for diff report
awrddrpi.sql -- Workload Repository Compare Periods Report
awrgdinp.sql -- Get inputs for global diff reports
awrgdrpi.sql -- Workload Repository Global Compare Periods Report
awrginp.sql -- AWR Global Input
awrgrpti.sql -- Workload Repository RAC (Global) Report
awrinpnm.sql -- AWR INput NaMe
awrinput.sql -- Get inputs for AWR report
awrsqrpi.sql -- Workload Repository SQL Report Instance
I usually carry copies of the scripts with me when I’m troubleshooting in case I need them at client sites – sometimes I’m not allowed the privileges I really need to do rapid troubleshooting, but if I can persuade the DBA to give me execute privileges on package dbms_workload_repository and select privileges on a couple of the necessary tables and views then I can run the reports from an otherwise “minimal” account.
There are also a couple of deceptively named files that you might miss in 11.2:
spawrrac.sql -- Server Performance AWR RAC report
spawrio.sql -- AWR IO Intensity Report
spadvrpt.sql -- Streams Performance ADVisor RePorT
Although the initial letters in the names suggest that these files might fall in with statspack, they actually report from the AWR tables – however the first one (spawrrac.sql) was only a temporary measure, and prints out the warning message:
This script will be deprecated. The official release of the Global AWR report is awrgrpt.sql
So if you’re using the spawrrac.sql – stop it.
- AWR Reports
- Oracle AWR Reports: Understanding I/O Statistics
- Automatic Workload Repository (AWR) Reports - Start Point (文档 ID 1363422.1)
- FAQ: How to Use AWR reports to Diagnose Database Performance Issues [ID 1359094.1]
- How to Read PGA Memory Advisory Section in AWR and Statspack Reports (文档 ID 786554.1)
- How to Read Buffer Cache Advisory Section in AWR and Statspack Reports. (文档 ID 754639.1)
- one command 一键收集 oracle 巡检信息(包含dbhc,awr reports)
- awr
- awr
- AWR
- AWR
- AWR
- awr
- AWR
- AWR
- awr
- crosstab reports
- Jasper Reports
- nginx安装
- oracle 分页优化
- linux常用命令—— 系统设置(八)
- Python基础语法
- Visual Studio 2012 编译错误【error C4996: 'scanf': This function or variable may be unsafe. 】的解决方案
- AWR Reports
- 生成一个url的二维码
- 【Python】Flask-RESTful使用
- java游戏服务端实现
- VIM选择文本块/复制/粘贴
- JQuery中DOM事件冒泡实例分析
- Python Django
- activiti 数据库配置错误:ORA-12505, TNS:listener does not currently know of SID given in connect desc
- 五个免费UML建模工具推荐