Hotsos Symposium Speaker – Andrew Zitelli

Andrew Zitelli is a returning Hotsos Symposium presenter.

Biography

Andrew ZitelliAndrew 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.

Presentation Title

Is Oracle's 10046 Tracing Still Relevant?

Abstract

Oracle databases include instrumentation which provides a detailed accounting of activities inside individual database sessions. Commonly referred to as 10046 tracing, this instrumentation has been used for Oracle performance problem diagnosis and 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 SQL Monitoring Report automatically collect and expose a wide range of runtime measurements. A frequently asked question is whether these newer tools have replaced 10046 tracing?

This presentation will describe the differences between 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 Oracle's other diagnostic tools. One of the key differences is in the methods used for data collection. 10046 trace data provides details based on state changes and events within individual database sessions. Other tools provide data based on periodic sampling. This presentation will discuss the strengths and weaknesses of each method, showing why data from these different methods answers different types of questions. The presentation will illustrate a variety of problems which can be solved using 10046 trace data while being difficult to solve using sampled data.

Presentation Materials

Presentation materials are available online to attendees only.

Schedule

The speaker schedule is as follows: