如何使用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 schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

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 enter an alternative.

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

相关推荐: Oracle 12c中怎么手动创建CDB

这期内容当中小编将会给大家带来有关Oracle 12c中怎么手动创建CDB，文章内容丰富且以专业的角度为大家分析和叙述，阅读完这篇文章希望大家可以有所收获。使用create database创建CDB的具体操作如下: 1.指定实例标识(SID) ORACLE_…