In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-19 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)05/31 Report--
This article mainly explains the "oracle database to generate awr report, ash report steps are", the article explained the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in-depth, together to study and learn "oracle database to generate awr report, ash report steps are what" it!
1. Detailed steps for generating awr
1. Manually generate AWR Snapshot number: execute (optional) exec dbms_workload_repository.create_snapshot under sqlplus
Execute under 2.sqlplus:
@? / rdbms/admin/awrrpt.sql
Or @ $ORACLE_HOME/rdbms/admin/awrrpt.sql
3. Enter the file format to generate the report
Type Specified: html
4. Enter the number of days between which the report will be generated
Enter value for num_days: 1
5. Enter the Snap Id start and end numbers between the separated snapshots
Specify the Begin and End Snapshot Ids
~ ~
Enter value for begin_snap: 101
Enter value for end_snap: 102
End Snapshot Id specified: 102
6. Enter the name of the generated report:
Enter value for report_name: awr.html
View awr reporting methods:
After generating the report, exit sqlplus, store the files in the current directory and copy them to your computer for viewing, or open linux's own browser and enter the directory.
File:///home/oracle/ awr.html II. Detailed steps for generating ash report:
Execute under 1.sqlplus:
@? / rdbms/admin/ashrpt.sql
Or @ $ORACLE_HOME/rdbms/admin/ashrpt.sql
two。 Enter the file format in which you want to generate the report, default html
Enter value for report_type:
3. Enter the start time. Before the default 15min, manually enter the number in minutes
Enter begin time for report:
-- Valid input formats:
-- To specify absolute begin time:
-- [MM/ DD [/ YY]] HH24:MI [: SS]
-- Examples: 02 Compact 23 Universe 03 14:30:15
-- 02Compare 23 14:30:15
-- 14:30:15
-- 14:30
-- To specify relative begin time: (start with'- 'sign)
-[HH24:] MI
-- Examples:-1:15 (SYSDATE-1 Hr 15 Mins)
-25 (SYSDATE-25 Mins)
Defaults to-15 mins
Enter value for begin_time:
4. Enter the interval, default to now
Enter duration in minutes starting from begin time:
Defaults to SYSDATE-begin_time
Press Enter to analyze till current time
Enter value for duration:
5. Enter the name of the generated report:
Enter value for report_name: ash.html
View ash reporting methods:
After generating the report, exit sqlplus and store the files in the current directory.
Thank you for your reading, the above is the content of "what are the steps for oracle database to generate awr report and ash report". After the study of this article, I believe you have a deeper understanding of what the steps for oracle database to generate awr report and ash report are, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!
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: 244
*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.