Oracle Active Session History (ASH)

Each second, the performance relevant figures for each active session are stored in memory.

The figures can be queried from v$active_session_history.

ASH can be used for diagnosing performance problems.

ASH is an integral part of the database self-management framework.