AWR报告 导出方法

1、登陆数据库服务命令行模式

2、进入/oracle/product/10.2.0/rdbms/admin下面

oracle@SD19pp7:/oracle$cd

/oracle/product/10.2.0/rdbms/admin

oracle@SD19pp7:/oracle/product/10.2.0/rdbms/admin$sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Thu Sep 20 11:19:05 2012

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @awrrpt

Current Instance

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

DB Id DB Name Inst Num Instance ----------- ------------ -------- ------------

1059119242 KMPRO 1 kmpro

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

1059119242 1 KMPRO kmpro SD11pp1 * 1059119242 1 KMPRO kmpro SD19pp7 1059119242 1 KMPRO kmpro SD10pp1

Using 1059119242 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: 2

Listing the last 2 days of Completed Snapshots

Snap Instance DB Name Snap Id Snap Started Level ------------ ------------ --------- ------------------ -----

kmpro KMPRO 26639 19 Sep 2012 00:00 1 260 19 Sep 2012 01:00 1 261 19 Sep 2012 02:00 1 262 19 Sep 2012 03:00 1 263 19 Sep 2012 04:00 1 2 19 Sep 2012 05:00 1 265 19 Sep 2012 06:00 1 266 19 Sep 2012 07:00 1 267 19 Sep 2012 08:00 1 268 19 Sep 2012 09:00 1 269 19 Sep 2012 10:00 1 26650 19 Sep 2012 11:00 1 26651 19 Sep 2012 12:01 1 26652 19 Sep 2012 13:00 1

26653 19 Sep 2012 14:00 1

266 19 Sep 2012 15:00 26655 19 Sep 2012 16:00 26656 19 Sep 2012 17:00 26657 19 Sep 2012 18:00

1 1 1 1

26658 19 Sep 2012 19:00 1 26659 19 Sep 2012 20:00 1 26660 20 Sep 2012 09:28 1 26661 20 Sep 2012 10:00 1 26662 20 Sep 2012 11:00 1

Specify the Begin and End Snapshot Ids

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

Enter value for begin_snap: 26639

End Snapshot Id specified: 26662

Enter value for end_snap: 26662

End Snapshot Id specified: 26662

Specify the Report Name

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

The default report file name is awrrpt_1_26639_26662.html. To use this name, press to continue, otherwise enter an alternative.

Enter value for report_name: 201209191140awr.html