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 [...]
