Hotsos Symposium Speaker – Toon Koppelaars

Toon Koppelaars is a returning Hotsos Symposium presenter.


Toon KoppelaarsToon Koppelaars is a long-time Oracle technology user and has been involved in application development as well as database administration.

Toon's special interest areas include: the Oracle Optimizer (SQL tuning), technical application architectures (from a performance and maintainability perspective), and the specification and implementation of data integrity rules (aka business rules). He is a frequent speaker at Hotsos Symposia, ODTUG, UKOUG and the Dutch Oracle User Group.

Together with Lex de Haan, he has co-authored "Applied Mathematics for Database Professionals" (Apress, June 2007).

In 2007, Mr. Koppelaars decided to go independent and founded his own company RuleGen B.V. (

Toon is an Oracle Ace.

Presentation Title

SQL Plan Management


This presentation will introduce the audience to the SQL Plan Management (SPM) feature. First, the general concepts and tooling around SPM will be discussed and demonstrated, and the audience will be made aware of a few SPM oddities showing it is not a silver bullet (yet?). The overview of SPM will constitute the majority of the talk. However, at the end, we will also discuss why and how SQL Plan Management was introduced into a large back-office application.

Presentation Materials

Presentation materials are available online to attendees only.


The speaker schedule is as follows: