In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.