This presentation is the first of two aims to help you use the Active Session History (ASH) repository to investigate performance problems. Oracle has produced many presentations that explain how ASH works, so this presentation provides only a very brief overview of how ASH works. Instead, it looks at:
what information is collected by
ASH and stored in the repository
where this data can be seen in
Enterprise Manager and other delivered reports,
the practicalities of how to directly query the ASH data to analyse and diagnose a range of performance and other problems,
the critical importance of
application instrumentation,
