This website uses cookies to store information on your computer. Some of these cookies are used for visitor analysis, others are essential to making our site function properly and improve the user experience. By using this site, you consent to the placement of these cookies. Click Accept to consent and dismiss this message or Deny to leave this website. Read our Privacy Statement for more.
11 June David Kurtz, Accenture Enkitec Group

Further Adventures in Active Session History


David Kurtz, Accenture Enkitec Group


 

Abstract

Part 1 of a two-part presentation - though this one could stand alone This session will look at the fundamentals of Active Session History (ASH); what it is, how it works, the concept of database time, how to use the sampled ASH data to profile your system or a process to determine where your performance problems lie. We will also look at the importance of proper instrumentation. Using some examples curated from real-life, we will see how ASH can be used to lead you directly to the root causes of some performance issues, and how to use ASH effectively when your application doesn't produce sharable SQL.

Speaker Biography

David Kurtz has worked with the Oracle database since 1989 and with PeopleSoft ERP applications since 1996, specialising in system performance tuning. He now works for the Accenture Enkitec Group as a performance tuning consultant. David is a regular presenter at Oracle and PeopleSoft conferences. He is the author of PeopleSoft for the Oracle DBA (www.psftdba.com), and blogs about PeopleSoft (blog.psftdba.com) and Oracle (blog.go-faster.co.uk). David is an Oracle ACE Director and a proud member of the Oak Table.