Search notes:
Oracle Active Session History (ASH)
Each second (?), the performance relevant figures for each active
session
are stored in memory.
ASH can be used for diagnosing
performance
problems.
ASH is an integral part of the
database self-management framework
.
See also
v$active_seession_history
v$ash_info
shows some information about the Active Session History sampling process.
$ORACLE_HOME/admin/rdbms/ashrpt.sql
is an
SQL*Plus
script to generate an ASH report.
oradebug dump ashdump
Index