oracle生成awr报告

最新推荐文章于 2024-01-16 09:05:09 发布

程序员石磊

最新推荐文章于 2024-01-16 09:05:09 发布

阅读量405

点赞数

分类专栏：数据库文章标签： oracle awr

版权

29 篇文章 0 订阅

订阅专栏

The awrrpt.sql SQL script generates an HTML or text report that displays statistics for a range of snapshot IDs.

To generate an AWR report:

At the SQL prompt, enter:
```
@$ORACLE_HOME/rdbms/admin/awrrpt.sql
```
Specify whether you want an HTML or a text report:
```
Enter value for report_type: text
```
In this example, a text report is chosen.
Specify the number of days for which you want to list snapshot IDs.
```
Enter value for num_days: 2
```
A list of existing snapshots for the specified time range is displayed. In this example, snapshots captured in the last 2 days are displayed.
Specify a beginning and ending snapshot ID for the workload repository report:
```
Enter value for begin_snap: 150
Enter value for end_snap: 160
```
In this example, the snapshot with a snapshot ID of 150 is selected as the beginning snapshot, and the snapshot with a snapshot ID of 160 is selected as the ending snapshot.
Enter a report name, or accept the default report name:
```
Enter value for report_name: 
Using the report name awrrpt_1_150_160
```
In this example, the default name is accepted and an AWR report named awrrpt_1_150_160 is generated.
报告位置在

D:\app\administrator\product\11.2.0\dbhome_1\BIN

关注