生成oracle awr 性能分析报告

在aix 或者 linux 环境下：

su - oracle

 

sqlplus '/ as sysdba'

 

SQL> @/oracle/app/oracle/product/11g/db/rdbms/admin/awrrpt.sql

 

Current Instance

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

 

   DB Id    DB Name      Inst Num Instance

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

 2207104388 SFE                 1 sfe

 

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

 

Type Specified:  9

 

Instances in this Workload Repository schema

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

 

   DB Id     Inst Num DB Name      Instance     Host

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

* 2207104388        1 SFE          sfe          hgpsfe01

  2207104388        1 SFE          sfe          hgpsfe02

 

Using 2207104388 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: 8

 

Listing the last 8 days of Completed Snapshots

 

                                                        Snap

Instance     DB Name        Snap Id    Snap Started    Level

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

sfe          SFE               2468 31 Dec 2010 00:00      1

                               2469 31 Dec 2010 01:00      1

                               2470 31 Dec 2010 02:00      1

                               2471 31 Dec 2010 03:00      1

                               2472 31 Dec 2010 04:00      1

                               2473 31 Dec 2010 05:00      1

                               2474 31 Dec 2010 06:00      1

                               2475 31 Dec 2010 07:00      1

                               2476 31 Dec 2010 08:00      1

                               2477 31 Dec 2010 09:00      1

                               2478 31 Dec 2010 10:09      1

                               2479 31 Dec 2010 11:00      1

                               2480 31 Dec 2010 12:17      1

                               2481 31 Dec 2010 13:00      1

                               2482 31 Dec 2010 14:00      1

                               2483 31 Dec 2010 15:00      1

                               2484 31 Dec 2010 20:04      1

                               2485 31 Dec 2010 21:00      1

                               2486 31 Dec 2010 22:00      1

                               2487 31 Dec 2010 23:00      1

                               2488 01 Jan 2011 00:00      1

                               2489 01 Jan 2011 01:00      1

                               2490 01 Jan 2011 02:00      1

                               2491 01 Jan 2011 03:00      1

 

 

Specify the Begin and End Snapshot Ids

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

Enter value for begin_snap: 2468

Begin Snapshot Id specified: 2468

 

Enter value for end_snap: 2487

End   Snapshot Id specified: 2487

 

......

 

最后要写好一个report name:

Report name : awrrpt20110107.html

 

生成的awr report 用ie 打开就可以了。