Part II: Further Adventures in Active Session History

  • This the second of two presentations about Active Session History (ASH).  ASH 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, Adaptive Plans, and analysis of PL/SQL.
    • Tracking temporary tablespace and PGA utilisation.
    • Analysis of the effectiveness of parallelism. 
    • Analysis of sources of I/O. 
    • Tracking transactions and executions. 
    • Some of the things that can go wrong with ASH and AWR, and how to work around them.
A video of this presentation (given at UKOUG2020) is available.