To generate ASH Report in an Oracle database. It’s simple and very easy, please follow the below steps.
ASH Report to identify performance bottlenecks.
ASH Report analyzes the actual root cause and provides the recommendations.
Full form of ASH Report:
Active Session History (ASH Report)
Just go to this below location:
$ORACLE_HOME/rdbms/admin
Remember: There are two types of formats to generate reports.
Text format.
HTML format.
To generate ASH Report execute the below query and follow the instructions.
At the SQL prompt, just hit enter:
@$ORACLE_HOME/rdbms/admin/ashrpt.sql
Please choose whether you want an HTML or a text report:
Enter value for report_type: html
In this example, a html report is chosen.
Please choose the specific time to generate ASH report, Begin time in minutes before the system date:
Enter value for begin_time: -20
In the above example, 20 minutes before the current time is selected.
Just specify the duration in minutes for which you want to get ASH information from the beginning time.
Enter value for duration:
The default duration of the system date should be minus the begin time, which is accepted.
Please enter the ASH report name, or leave it for the default report name:
Enter value for report_name:
Using the report name ashrpt_05_01_2025.txt