Hotsos Symposium Speaker – Gary Propeck

Gary Propeck is a new Hotsos Symposium presenter.

Biography

Gary PropeckGary has a Ph.D. In Physical Organic Chemistry, University of South Florida, 1984. In 1990, while working at a nuclear weapons facility, he began working with the Oracle Database in a chemistry laboratory environment. In 1995, Gary went to work for Oracle Education (now Oracle University) as an instructor. Gary taught the OU curricula for Database Administration, Tools (Forms, Reports, etc.), Oracle Application Server, and Languages (SQL, PL/SQL, and Java). During that time Gary made numerous presentations at events such as Open World and RMOUG Training Days.

In 2002, Gary went to work for Corporate Express as a DBA, gaining more experience working with the Oracle Database. In July, 2004, Gary decided to go back to teaching as an independent contractor, teaching much of the same curricula as before, while adding new courses such as OEM and Apex to his repertoire. 2009 brought Gary to Hotsos, as he began teaching as a contractor. In August, 2010, Gary started teaching as a Hotsos employee where he teaches the Performance Optimization curriculum.

Presentation Title

The CBO's Look at Clusters, IOTs, Partitions, and other Objects

Abstract

When we looked at the rules from the Oracle RBO, one could find individual rules for using various types of indexes and clusters. As Oracle began to phase out the RBO, noticeably absent were improvements or changes to the RBO to accommodate objects such as IOTs and partitions. To use such objects one is required to use the CBO. This presentation details the use of the 10053 CBO trace to compare the use of heap tables versus clusters, IOTs, and partitions. Items of interest will include gathering statistics at various granularities of partitions and examining their use via the 10053 CBO trace.

Presentation Materials

Presentation materials are available online to attendees only.

Schedule

The speaker schedule is as follows: