Hotsos Symposium Speaker – Gary Propeck

Gary Propeck is a returning Hotsos Symposium presenter.

Biography

Gary PropeckGary has a Ph.D. in Physical Organic Chemistry from the University of South Florida in 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 Tuning curriculum. Gary presented the paper "The CBO's Look at Clusters, IOTs, Partitions, and other Objects" at the 2011 Hotsos Symposium.

Presentation Titles

SPM Examined

Abstracts

SQL plan management (SPM) provides a mechanism for maintaining consistent SQL performance regardless of changes in optimizer version, optimizer statistics, schema changes, system settings and SQL profile creation. SPM uses the SQL Management Base (SMB) to store SQL Plan Baselines. SPM can be managed from the command line or through Oracle Enterprise Manager. (OEM).

When performance improves, SPM can create a new baseline for that improved performance. This paper follows the course of SQL statements (single table queries and multi-table queries), managed by SPM. The tables used are created with minimal data and no indexes. SPM will then be monitored as the data grows and other objects such as B-tree indexes, function-based indexes, bitmap indexes, and partitioning are added to the mix. We will monitor how the execution plan evolves with data growth and object addition, using the Hotsos Harness Tools to generate statistics and various trace files, in both the 11g and 12c Oracle databases.

Presentation Materials

Presentation materials are available online to attendees only.

Schedule

The speaker schedule is as follows: