February 2012
M T W T F S S
« Apr    
 12345
6789101112
13141516171819
20212223242526
272829  

How to Interpret the Active Session History and Draw Histogram Using OMonitor

1. Introduce
The ASH(Active Session History) is the innovative improvement in 10g.
ASH records the activities of Oracle, sampling per second, if a session is using on CPU or waiting on resource, such as db file sequential read, log file sync, latch etc, then this session is considered to be active, and recorded down in the v$active_session_history [...]