收集关于SQL的运行报告方法

收集关于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:

1. At the SQL prompt, enter:

@$ORACLE_HOME/rdbms/admin/awrsqrpt.sql

1. Specify whether you want an HTML or a text report:

Enter value for report_type: html

In this example, an HTML report is chosen.

1. 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.

1. 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.

1. 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.

1. 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.

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

转载于:http://blog.itpub.net/29346172/viewspace-2158198/