How To Generate ASH (Active Session History) Report
To generate ASH report:
@$ORACLE_HOME/rdbms/admin/ashrpt.sql
The report provides below areas:
1. Top User Events
2. Top Service/Module
3. Top SQL Command Types
4. Top Sessions
5. Top Blocking Sessions
6. Top DB Objects
7. Top Phases of Execution
8. Top PL/SQL Procedures
9. Top SQL With Top Row Sources
11. Complete list of SQL text
12. Activity Over Time
No comments:
Post a Comment