如何使用awrrpt.sql 生成AWR报告

本篇内容主要讲解“如何使用awrrpt.sql 生成AWR报告”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“如何使用awrrpt.sql 生成AWR报告”吧!使用 /home/oracle/app/oracle/product/11.2.9/dbhome_1/rdbms/admin/awrrpt.sql 脚本生成awr报告oracle@linux:~>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on 星期三 8月 19 07:34:53 2015

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>@/home/oracle/app/oracle/product/11.2.9/dbhome_1/rdbms/admin/awrrpt.sql awrrpt.sql 该脚本的绝对路径；

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

DB Id DB Name Inst Num Instance
———– ———— ——– ————
1407296662 ORCL 1 orcl

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 报告类型，html或textInstances in this Workload Repository schem免费主机域名a
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

DB Id Inst Num DB Name Instance Host
———— ——– ———— ———— ————
* 1407296662 1 ORCL orcl linux

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

Enter value for num_days:1 要生成报告的天数，默认是7天

Listing the last day’s Completed Snapshots

Snap
Instance DB Name Snap Id Snap Started Level
———— ———— ——— —————— —–
orcl ORCL 2179 19 8月 2015 00:00 1
2180 19 8月 2015 01:00 1
218119 8月 2015 02:00 1
2182 19 8月 2015 03:00 1
2183 19 8月 2015 04:00 1
2184 19 8月 2015 05:00 1
2185 19 8月 2015 06:00 1
2186 19 8月 2015 07:00 1

Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap:2181 开始快照的id 如：2181Begin Snapshot Id specified: 2181

Enter value for end_snap:2183 结束快照的id 如：2183
End Snapshot Id specified: 2183

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_2181_2183.html. To use this name,
press to continue, otherwise ente免费主机域名r an alternative.

Enter value for report_name:awrrpt_1_2181_2183.html 生成报告的名称……………………………………..

相关推荐: MySQL数据库无法删除的解决方法

本篇内容介绍了“MySQL数据库无法删除的解决方法”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！首先找到mysql的school路径，在该路径下通常会有些文件是…