为一条sql生成awr报告
SQL> @awrsqrpt.sqlCurrent Instance
~~~~~~~~~~~~~~~~
DB> ----------- ------------ -------- ------------
1607542246 CWRPT 1 CWRPT
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> ------------ -------- ------------ ------------ ------------
* 1607542246 1 CWRPT CWRPT aix
Using 1607542246 for database> 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.Pressingwithout
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> ------------ ------------ --------- ------------------ -----
CWRPT CWRPT 20956 03 Nov 2015 00:00 1
20957 03 Nov 2015 01:00 1
20958 03 Nov 2015 02:00 1
20959 03 Nov 2015 03:00 1
20960 03 Nov 2015 04:00 1
20961 03 Nov 2015 05:00 1
20962 03 Nov 2015 06:00 1
20963 03 Nov 2015 07:00 1
20964 03 Nov 2015 08:00 1
20965 03 Nov 2015 09:00 1
20966 03 Nov 2015 10:00 1
Specify the Begin and End Snapshot> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 20963
Begin Snapshot> Enter value for end_snap: 20964
End Snapshot>
Specify the SQL> ~~~~~~~~~~~~~~~~~~
Enter value for sql_id: gw73k376kp9g3
SQL> Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is awrsqlrpt_1_20963_20964.html.To use this name,
pressto continue, otherwise enter an> Enter value for report_name: /home/oracle/awrsqlrpt_1_20963_20964.html
Using the report name /home/oracle/awrsqlrpt_1_20963_20964.html
页:
[1]