Further Adventures in Active Session History
(Tuesday 8th December, 3.00-3.45pm)
(Tuesday 8th December, 3.00-3.45pm)
Active Session History can tell you far more than simply how much time was spent in a particular SQL statement. This presentation shows how to deal with some of the challenges of manipulating ASH data and various ways to use it to investigate performance problems. Including:
- Dealing with the consequences of literal values in SQL,
- Adaptive Plans,
- Multi-node RAC systems,
- Analysis of PL/SQL.
- Analysis of the effectiveness of parallelism.
- Tracking transactions and executions.
- Analysis of sources of I/O.
We will also look at some of the things that can go wrong with ASH and AWR, and how to work around them.