手工生成awr报告

加入收藏设为首页

Oracle优化: 手工生成awr报告
时间：2013/9/7 20:23:32 作者：www.solgle.com 来源：说歌社区查看：427 评论：0
内容摘要：运行sqlplus，进入系统如：sqlplus sys/pwd@dbname as sysdba; ...SQL> @?\RDBMS\ADMIN\awrrpt.sql;Current Instance~~~~~~~~~~~~~~~~DB Id DB Name Inst Nu...
运行sqlplus，进入系统
如：sqlplus sys/pwd@dbname as sysdba;
...
SQL> @?\RDBMS\ADMIN\awrrpt.sql;

Current Instance
~~~~~~~~~~~~~~~~

DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
4240648358 SAP2HQ 1 sap2hq

Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Would you like an HTML report, or a plain text report?
Enter 'html' for an HTML report, or 'text' for plain text
Defaults to 'html'
Enter value for report_type: html

Type Specified: html -- 指定输出文件类型格式

Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

DB Id Inst Num DB Name Instance Host
------------ -------- ------------ ------------ ------------
* 4240648358 1 SAP2HQ sap2hq SERVER3-E982
B1E

Using 4240648358 for database Id
Using 1 for instance number

Specify 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> without
specifying a number lists all completed snapshots.

Enter value for num_days:1 -- 输入快照的天数

Listing the last day's Completed Snapshots

Snap
Instance DB Name Snap Id Snap Started Level
------------ ------------ --------- ------------------ -----
sap2hq SAP2HQ 840 14 Nov 2012 00:28 1
841 14 Nov 2012 02:00 1
842 14 Nov 2012 03:00 1
843 14 Nov 2012 04:00 1
844 14 Nov 2012 05:00 1
845 14 Nov 2012 06:00 1
846 14 Nov 2012 07:00 1
847 14 Nov 2012 08:00 1

Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 840 -- 输入开始snap
Enter value for end_snap: 844 -- 输入结束snap
End Snapshot Id specified: 844

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_840_844.html. To use this name,
press <return> to continue, otherwise enter an alternative.

Enter value for report_name:c:\awr-840-844.html -- 输入报告文件名

标签：手工生成awr报告


solgle.com 版权所有，欢迎分享！！！

上一篇：Oracle内存诊断
下一篇：如何分析awr报告

相关文章

相关评论

本类更新

本类推荐

本类排行

: 国家数据 | 中证指数 | Oracle官方文档 | 沪深行情 | 流量统计 | 深交所 | 上交所 | 中国证券登记 | 同业拆放利率 | 巨潮资讯 | 指数估值 | 看财报 |

联系我们 - 关于我们 - 网站同盟