oracle命令生成AWR报告

--命令生成AWR报告
oracle@linux:~> sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Fri Aug 17 16:22:15 2012

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

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

SQL> @$ORACLE_HOME/rdbms/admin/awrrpt.sql

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

   DB Id    DB Name  Inst Num Instance
----------- ------------ -------- ------------
 2933263778 MSGPLUS  1 msgplus

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
------------ -------- ------------ ------------ ------------
* 2933263778     1 MSGPLUS    msgplus linux-254

Using 2933263778 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: 1

Listing the last day's Completed Snapshots

       Snap
Instance     DB Name     Snap Id    Snap Started    Level
------------ ------------ --------- ------------------ -----
msgplus      MSGPLUS   72 24 May 2012 00:00    1
     73 24 May 2012 01:00    1
     74 24 May 2012 02:00    1
     75 24 May 2012 03:00    1
     76 24 May 2012 04:00    1
     77 24 May 2012 05:00    1
     78 24 May 2012 06:00    1
     79 24 May 2012 07:00    1
     80 24 May 2012 08:00    1
     81 24 May 2012 09:00    1

 

Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 80
Begin Snapshot Id specified: 80

Enter value for end_snap: 81
End   Snapshot Id specified: 81

 

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrrpt_1_80_81.html.  To use this name,
press <return> to continue, otherwise enter an alternative.

Enter value for report_name: /home/oracle/awrrpt_1_80_82.html

转载于:https://www.cnblogs.com/wensiyang0916/p/5832463.html