Hotsos Symposium 2012 will be held March 4-8, 2012 in Irving, TX. There will be 31 speakers and 36 sessions dedicated to Oracle performance. Where else can you get this kind of in-depth discussion dedicated to Oracle performance? Plus, Jonathan Lewis is hosting the optional Training Day. Register today! You don't want to miss the 10th anniversary of Hotsos Symposium.
Title: Is Oracle 10046 Tracing Still Relevant?
Abstract: Oracle databases include instrumentation which provides a detailed chronological accounting of activities inside individual database sessions. Commonly referred to as 10046 tracing, this instrumentation has been used as a powerful tool for Oracle performance problem diagnosis and software debugging since the late 1990's. In recent years, Oracle has released other diagnostic tools, which collect a broad range of details regarding runtime activities throughout a database. Tools like ASH, AWR, V$ performance views and Oracle Enterprise Manager automatically collect and expose a wide range of runtime measurements. A commonly asked question is whether these more recent tools have replaced 10046 tracing?
This presentation will describe the differences between the details provided by 10046 tracing and those provided by Oracle's other tools. It will show why 10046 trace data is fundamentally different than the data provided by any of Oracle's other diagnostic tools. One of the key differences is between the methods used for data collection. 10046 trace data collects details based on state changes within individual database sessions. Other tools provide summarized data based on periodic sampling. Sampled results are good enough for investigating many problems but can be prone to significant omissions and inaccuracies.
Biography: Andrew Zitelli has over thirty years of experience as a software developer, data architect and performance analyst. He has served as a consultant to the aerospace, semiconductor, steel, and pharmaceutical industries. Andrew is proficient working with a broad range of operating systems and languages and has over 25 years experience working with ten different relational database products, including 20 years working with Oracle. He holds MS and BA degrees in Computer Science.
Andy has previously presented at Hotsos Symposia in 2007, 2008, 2009, 2010 and 2011, as well as other recent conferences in California, Texas and Michigan. Andy is a member of the OakTable Network.
Don't miss it!