UKOUG2020

UKOUG Conference 2020, 1,2,8 & 9 December 2020

I will be speaking at the UKOUG Conference 2020.  It is entirely online this year on 4 afternoons in December.

UKOUG Techfest19 - I am on the line-up
Further Adventures in Active Session History
(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.