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 18 years working with Oracle. He holds MS and BA degrees in Computer Science.

Andy is a previous presenter on Oracle performance topics at Hotsos Symposia in 2007, 2008, 2009, and 2010. In 2010, he also presented at the Michigan OakTable Symposium (MOTS) and the Northern California Oracle User's Group (NoCOUG). Andrew is a member of the OakTable Network.

Presentation Title

Four Things Every Developer (and DBA) Should Know about Oracle

Abstract

An idea being widely propounded among many software developers is that software should be allowed to freely access data without any regard for how or where the data is stored. Although this idea sounds appealing, it frequently fails in practice. Software applications which treat data storage as a "black box" often suffer from widespread problems with performance, contention issues, and high resource consumption. These problems can severely diminish the effectiveness of multithreading, added hardware, and other techniques used to support high application throughput and low response times.

This presentation will examine four areas where a lack of understanding of Oracle has repeatedly led to costly design flaws, directly responsible for performance problems. These topics will cover COMMITs and ROLLBACKs, unique identifiers, use of DBMS_LOCK by application code, and why you should filter data in the database instead of an application. The intent of the presentation is to help both developers and DBAs understand, recognize, and avoid several common pitfalls arising from the "black box" approach to data storage.

Presentation Materials

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

Schedule

The speaker schedule is as follows: