Papers / Presentations

Below you will find a list, in reverse chronological order, of papers I (co)-wrote and published over the last few years as well as presentations I created and presented at various user group meetings throughout Europe.

• Database Smart Flash Cache

This presentation is an introduction to the Database Smart Flash Cache feature which was introduced in Oracle11gR2 (version 11.2.0.2.0). The SFC demo output was captured for your convenience. I presented this presentation on November 28 2011 for the Oracle Gebruikersgroep Holland (OGH) and on December 7 2011 at the UKOUG Annual Conference in Birmingham (UK).

• Adaptive Cursor Sharing

This presentation is an introduction to the Adaptive Cursor Sharing feature which was introduced in Oracle11g. The ADC demo output was captured for your convenience. I presented this presentation on November 17 2010 for the Oracle Gebruikersgroep Holland (OGH).

• Real Application Testing

This presentation is an introduction to the Real Application Testing feature which was introduced in Oracle11g. I presented this presentation on May 8 2010 at the 5th Planboard DBA Symposium.

• SQL Plan Management

This presentation discusses various techniques that can be used to prevent the optimizer from selecting sub-optimal execution plans with a focus on the Oracle11g SQL Plan Management feature. The SPM demo output was captured for your convenience. I presented this both at the 3rd Planboard DBA Symposium and the 2009 UK OUG Annual Conference.

• Oracle Database 11g: Data Guard New Features in Action

This presentation introduces the Oracle11g Data Guard new features companioned by live demos. I presented this presentation on November 17 2009 at the 4th Planboard DBA Symposium.

• SQL Plan Management

This paper (in Dutch) discusses the Oracle11g SQL Plan Management feature. This paper was first published in the September 2009 issue of Optimize magazine.

• Installing Oracle DBA 1.0

This paper, co-written by Joel Goodman and myself, discusses the skillset required by entry level and prospective Oracle DBAs to help them get started in their career and acts as a guide to creating a pickup plan for Oracle DBA skills. This paper was first published on the Oracle Certification Blog.

• Unmasking your IP Addresses

This paper discusses the network skills required to maintain IP based Oracle Clusterware interconnects. This paper was first published in the March 2009 issue of the Oracle University Technology Newsletter.

• What’s the Point of Oracle Checkpoints

This presentation explains the diferent types of checkpoints that can occur in an Oracle database. I presented this presentation at the November 2008 edition of the Dutch Planboard DBA Symposium and at the 2008 UKOUG anual conference.

• Performing an Oracle DBA 1.0 to DBA 2.0 Upgrade

This paper, co-written by Joel Goodman and myself, discusses the required change in skillset for a typical DBA in order to remain effective in maintaining modern Oracle environments. This paper was first published on the Oracle Certification Blog.

• SQL*Plus’s Forgotten History

This paper discusses a solution to SQL*Plus’s lack of command line editing functionality and history support. This paper was first published in the October 2008 issue of the Oracle University Technology Newsletter.

• Become an Oracle Certified Expert in RAC

This paper, co-written by Joel Goodman and myself, discusses some concepts and Sample Questions on the Oracle Expert Certification OCP exam in RAC. This paper was first published in the January 2008 issue of OracleMagazine.

• client Connectivity in a DataGuard Environment

This presentation discusses a solution for client connectivity issues in an Oracle DataGuard environment. I presented this presentation at the 2007 UKOUG conference and at the May 2008 edition of the Dutch Planboard DBA Symposium.

• CLUVFY’s Complaint & "10."

This paper discusses CLUVFY’s complaint about the usage of non-routable IP addresses as VIP’s in an Oracle10g RAC environment.