Oracle 11g 手工跑AWR报告

[root@test ~]# su - oracle
[oracle@test ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 17 21:28:22 2017
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

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

SQL> @?/rdbms/admin/awrrpt.sql;
Current Instance
~~~~~~~~~~~~~~~~


   DB Id    DB Name      Inst Num Instance
----------- ------------ -------- ------------
  879502600 SCPRD               2 SCPRD2




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
------------ -------- ------------ ------------ ------------
* 879502600         2 SCPRD        SCPRD2       wmsbjdb2
  879502600         1 SCPRD        SCPRD1       wmsbjdb1


Using  879502600 for database Id
Using          2 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
------------ ------------ --------- ------------------ -----
SCPRD2       SCPRD            11337 17 Oct 2017 00:00      1
                              11338 17 Oct 2017 01:00      1
                              11339 17 Oct 2017 02:00      1
                              11340 17 Oct 2017 03:00      1
                              11341 17 Oct 2017 04:00      1
                              11342 17 Oct 2017 05:00      1
                              11343 17 Oct 2017 06:00      1
                              11344 17 Oct 2017 07:00      1
                              11345 17 Oct 2017 08:00      1
                              11346 17 Oct 2017 09:00      1
                              11347 17 Oct 2017 10:00      1
                              11348 17 Oct 2017 11:00      1
                              11349 17 Oct 2017 12:00      1
                              11350 17 Oct 2017 13:00      1
                              11351 17 Oct 2017 14:00      1
                              11352 17 Oct 2017 15:00      1
                              11353 17 Oct 2017 16:00      1
                              11354 17 Oct 2017 17:00      1
                              11355 17 Oct 2017 18:00      1
                              11356 17 Oct 2017 19:00      1
                              11357 17 Oct 2017 20:00      1
                              11358 17 Oct 2017 21:00      1






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


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






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


Enter value for report_name: 
Using the report name awrrpt_2_11346_11347.html

......

<p />
End of Report
</body></html>
Report written to awrrpt_2_11346_11347.html

生成的AWR的html文件在当前目录下。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22996654/viewspace-2146079/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22996654/viewspace-2146079/