Active Session History (ASH)

The Oracle wait event model was originally introduced in Oracle7. Wait event information is gathered by the Oracle MMON background process, stored in intermediate x$ structures in a circular SGA buffer, and later transferred to Oracle10g dba_hist tables. Oracle 10g introduced the Active Session History (ASH) as part of the Diagnostics and Tuning Read more…