Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to generate AWR reports using awrrpt.sql

2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

This article focuses on "how to use awrrpt.sql to generate AWR reports", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn how to use awrrpt.sql to generate AWR reports.

Generate awr reports using the / home/oracle/app/oracle/product/11.2.9/dbhome_1/rdbms/admin/awrrpt.sql script

Oracle@linux:~ > sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wednesday August 19 07:34:53 2015

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL > @ / home/oracle/app/oracle/product/11.2.9/dbhome_1/rdbms/admin/awrrpt.sql awrrpt.sql the absolute path to the script

Current Instance

~

DB Id DB Name Inst Num Instance

--

1407296662 ORCL 1 orcl

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 report type, html or text

Instances in this Workload Repository schema

~

DB Id Inst Num DB Name Instance Host

--

* 1407296662 1 ORCL orcl linux

Using 1407296662 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 the number of days to generate the report. Default is 7 days.

Listing the last day's Completed Snapshots

Snap

Instance DB Name Snap Id Snap Started Level

--

Orcl ORCL 2179 19 August 2015 00:00 1

2180 19 August 2015 01:00 1

2181 19 August 2015 02:00 1

2182 19 August 2015 03:00 1

2183 19 August 2015 04:00 1

2184 19 August 2015 05:00 1

2185 19 August 2015 06:00 1

2186 19 August 2015 07:00 1

Specify the Begin and End Snapshot Ids

~ ~

Enter value for begin_snap: 2181 id for starting snapshots, such as 2181

Begin Snapshot Id specified: 2181

Enter value for end_snap: 2183 id of the end snapshot, such as 2183

End Snapshot Id specified: 2183

Specify the Report Name

~ ~ ~

The default report file name is awrrpt_1_2181_2183.html. To use this name

Press to continue, otherwise enter an alternative.

Enter value for report_name: the name of the report generated by awrrpt_1_2181_2183.html

....

When Report written to awrrpt_1_2181_2183.html sees this representation, it is generated successfully.

Oracle@linux:~ > ll / home/oracle/awrrpt_1_2181_2183.html

-rw-r--r-- 1 oracle dba 379333 2015-08-19 07:38 / home/oracle/awrrpt_1_2181_2183.html

Saved by default under the path of / home/oracle

At this point, I believe you have a deeper understanding of "how to use awrrpt.sql to generate AWR reports". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report