Oracle Tips by Burleson
Oracle 10g Active Session History
The Active Session History (ASH) represents the
history of a recent session’s activity. ASH facilitates the analysis
of the system performance at the current time. ASH is composed of
regular samples of information extracted from v$session. ASH is
designed as a rolling buffer in memory, and earlier information is
overwritten when needed. ASH uses the memory of the SGA.