awr报告生成

SQL>  @?/rdbms/admin/awrrpt.sql


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


   DB Id    DB Name      Inst Num Instance
----------- ------------ -------- ------------
  249066282 ORA11GR2            1 ORA11GR2




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: 


Type Specified:  html




Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


   DB Id     Inst Num DB Name      Instance     Host
------------ -------- ------------ ------------ ------------
* 249066282         1 ORA11GR2     ORA11GR2     zh


Using  249066282 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
------------ ------------ --------- ------------------ -----
ORA11GR2     ORA11GR2             5 15 Jan 2017 11:18      1
                                  6 15 Jan 2017 12:00      1
                                  7 15 Jan 2017 13:00      1
                                  8 15 Jan 2017 14:00      1


                                  9 15 Jan 2017 15:51      1
                                 10 15 Jan 2017 17:00      1
                                 11 15 Jan 2017 18:00      1






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


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






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


Enter value for report_name: hr


Using the report name hr
<li class="awr">'(NULL)' indicates a missing parameter value </li>
<li class="awr"> A blank in the End Snapshot indicates the same value as the BeginSnapshot</li>
</ul>
<table border="0" class="tdiff" summary="This table displays name and value of multi-valued init.ora parameters"><tr><th class="awrbg" scope="col">Parameter Name</th><th class="awrbg" scope="col">Begin value</th><th class="awrbg" scope="col">End value (if different)</th></tr>
<tr><td scope="row" class='awrc'>control_files</td><td class='awrc'>/u01/app/oracle/oradata/ORA11GR2/control01.ctl</td><td class='awrc'>&#160;&#160;</td></tr>
<tr><td scope="row" class='awrnc'><div class="hidden">control_files

转载于:http://blog.itpub.net/31399171/viewspace-2132463/