Oracle 10g introduced the Active Session History (ASH) as part of the Diagnostics and Tuning Pack. ASH stands for Active Session History. An ASH report details statistics from the in-memory performance monitoring tables.
The report provides:
Top User Events.
Details to the wait events
Top Queries
Top Sessions
Top Blocking Sessions
Top DB Objects
The simplest way to generate this report is through the Oracle Enterprise Manager tool (OEM); however, there are times when this tool is not available. On those occasions, the DBA user can generate the report manually.
To generate the ASH report:
Log in to the database.
At a command prompt issue the following command
@$ORACLE_HOME/rdbms/admin/ashrpt.sql
The script prompts you for the following details:
Report Type: [ html | text ] (Specify a format for the report).
Enter value for begin_time: Specify the begin time for the report and press Enter (e.g., -1:30 is one hour and 30 minutes before from the present time).
Enter value for duration: Specify the duration for the report and press Enter (for example, a value of 30 indicates that the report should cover from the begin time to 30 minutes after that time;
leaving the duration empty specifies that the report should cover from the begin time to the current time).
Enter value for report_name: Name the report and press Enter.
The report is generated at the path where the SQLPlus command was issued.
The script produces either text or HTML output as requested.
No comments:
Post a Comment
Ask your Questions....