Hotsos Symposium Speaker – Andrew Zitelli

Andrew Zitelli is a returning Hotsos Symposium presenter.


Andrew ZitelliAndrew Zitelli has 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 25 years experience working with ten different relational database products, including 17 years working with Oracle. He holds MS and BA degrees in Computer Science. During the past 30 years, Andrew has taught college-level courses and made presentations at technical conferences and other venues on a wide range of topics. He made presentations at the Hotsos Symposiums in 2007, 2008 and 2009. Andrew is a member of the Oak Table Network.

Presentation Title

Oracle 11g "Partitioning by Reference" — the Advantages and Annoyances


Oracle 11g adds support for a powerful new type of partitioning named "partitioning by reference." Unlike other partitioning methods which partition tables individually, "partitioning by reference" supports complex, nested hierarchies of tables, all partitioned together under a single root table. Under appropriate circumstances, this partitioning method can significantly simplify the management and aging out of complex data. This presentation will examine advantages, disadvantages, and a wide range of other considerations related to the use of partitioning by reference. It will also illustrate how Oracle's 10046 Extended SQL Trace Data and controlled experiments can be used to analyze and better understand the behavior of this new feature.

Presentation Materials

Presentation materials are available online to attendees only. Mr. Zitelli's presentation slides and white paper will be available upon receipt.


The speaker schedule is as follows: