指定oracle11awr报告的路径,oracle的awr报告导出

连接到:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

--执行脚本

SQL>@/home/oracle/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/awrrpt.sql;

Current Instance

~~~~~~~~~~~~~~~~

DB Id   DB Name     Inst Num Instance

----------- ------------ -------- ------------

1316098433 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'

输入report_type的值: html

--按html格式导出

Type Specified: html

Instances in this Workload Repository schema

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

DB Id    Inst Num DB Name     Instance    Host

------------ -------- ------------ ------------ ------------

* 1316098433       1 ORCL        ORCL        108.local

Using 1316098433 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.

--导出天数

输入num_days的值: 1

Listing the last day's Completed Snapshots

Snap

Instance    DB Name       Snap Id   Snap Started   Level

------------ ------------ --------- ------------------ -----

ORCL        ORCL            11300 23 12月2013 00:00    1

11301 23 12月2013 01:00    1

11302 23 12月2013 02:00    1

11303 23 12月2013 03:00    1

11304 23 12月2013 04:00    1

11305 23 12月2013 05:00    1

11306 23 12月2013 06:00    1

11307 23 12月2013 07:00    1

11308 23 12月2013 08:00    1

11309 23 12月2013 09:00    1

11310 23 12月2013 10:00    1

11311 23 12月2013 11:00    1

--起止Snap Id

Specify the Begin and End Snapshot Ids

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

输入begin_snap的值: 11300

Begin Snapshot Id specified: 11300

输入end_snap的值: 11310

End  Snapshot Id specified: 11310

Specify the Report Name

~~~~~~~~~~~~~~~~~~~~~~~

The default report file name is awrrpt_1_11300_11310.html. To use this name,

press to continue, otherwise enter an alternative.

--导出文件文件名，如果没有指定导出路径，oracle导出到当前目录。

输入report_name的值: /home/oracle/awrrpt20131223.html