為一條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 <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

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

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 <return> 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