|11 June David Kurtz, Accenture Enkitec Group|
Further Adventures in Active Session History
David Kurtz, Accenture Enkitec Group
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.
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.