为一条sql生成awr报告

SQL> @awrsqrpt.sql

Current Instance

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

DB Id DB Name Inst Num Instance

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

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 Id Inst Num DB Name Instance Host

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

* 1607542246 1 CWRPT CWRPT aix

Using 1607542246 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 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

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

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 Ids

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

Enter value for begin_snap: 20963

Begin Snapshot Id specified: 20963

Enter value for end_snap: 20964

End Snapshot Id specified: 20964

Specify the SQL Id

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

Enter value for sql_id: gw73k376kp9g3

SQL ID specified: gw73k376kp9g3

Specify the Report Name

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

The default report file name is awrsqlrpt_1_20963_20964.html. To use this name,

press to continue, otherwise enter an alternative.

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

Using the report name /home/oracle/awrsqlrpt_1_20963_20964.html