收集关于SQL的运行报告方法： 5.3.6.5 Generating an AWR Report for a SQL Statement The awrsqrpt.sql SQL script generates an HTML or text report that displays statistics of a particular SQL statement for a range of snapshot IDs. Run this report to inspect or debug the performance of a SQL statement. To generate an AWR report for a particular SQL statement:
At the SQL prompt, enter:
@$ORACLE_HOME/rdbms/admin/awrsqrpt.sql
Specify whether you want an HTML or a text report:
Enter value for report_type: html In this example, an HTML report is chosen.
Specify the number of days for which you want to list snapshot IDs.
Enter value for num_days: 1 A list of existing snapshots for the specified time range is displayed. In this example, snapshots captured in the previous day are displayed.
Specify a beginning and ending snapshot ID for the workload repository report:
Enter value for begin_snap: 146 Enter value for end_snap: 147 In this example, the snapshot with a snapshot ID of 146 is selected as the beginning snapshot, and the snapshot with a snapshot ID of 147 is selected as the ending snapshot.
Specify the SQL ID of a particular SQL statement to display statistics:
Enter value for sql_id: 2b064ybzkwf1y In this example, the SQL statement with a SQL ID of 2b064ybzkwf1y is selected.
Enter a report name, or accept the default report name:
Enter value for report_name: Using the report name awrrpt_1_146_147.html In this example, the default name is accepted and an AWR report named awrrpt_1_146_147 is generated.
