My Articles & Presentations
Here is a list of User Group presentations and articles that I wrote or co-authored and published in the past few years. Presentations were made to the UK Oracle User Group Conference, at DBA SIGs or both. Articles have been published in the EMEA Education newsletter on the Certification Blog and elsewere.
This session was presented on 30/11/2009 at the UKOUG Annual Conference and examines remote and distributed queries and transactions over database links. The problem of multiple transaction branches involving RAC database instances are explored followed by Oracle Single Phase and Two Phase commit processing over DB Links including: Prepare, Response to Prepare, Commit/Rollback and Forget phases. Next is a discussion of two phase commit in-doubt failures and resolution using the Recoverer Process (RECO) or DBA manual resolution. Finally the implications of Point in Time Recovery on Distributed Databases is examined.
This presentation was delivered to the UKOUG DBA SIGs this year and it examines the architecture, creation,monitoring and use of Database Links in distributed systems. It covers the attributes of Database Links in three dimensions: Firstly “Fixed User”, “Connected User” and “Current User” Database Links, then “Shared” and”Non-Shared” Database Links, and finally “Private”, “Public” and “Global” Database Links. It also describes Global Naming and its implications for DB links and the use of DB Link Qualifiers in RAC, for specific database instance DB Links, the use of DB Links in remote and distributed queries and the use of Database Synonyms to provide Location Transparency.
This presentation created with the help of Julia Johnson of the Oracle Certification Management team was presented to a group of EMEA managers online and discusses the benefits of Oracle certification to both employer and employee and an insight into the design philosophy underlying both theory style certification exams used for OCA, OCP and OCE as well as performance style exams used for OCM.
This paper, co-written by Harald van Breederode 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.
This paper, co-written by Harald van Breederode 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.
This article appeared in the Oracle University EMEA newsletter last year and discusses the management of Oracle Sequences in a single instance environment covering administration, monitoring and performance issues.
This article first appeared in the Oracle University newsletter last year and discusses the use of “Module and Action” monitoring to help identify which parts of an application are consuming the most resources.
This Presentation was made to two different UKOUG SIGs in 2008 to provide an overview of the current Oracle DBA Certification tracks and an insight into the development process for Certification Exams.
This Presentation was made in 2008 to the UK Oracle Usere Group RAC SIG, the Oracle RAC SIG run by Oracle as a Webcast and also delivered at the UKOUG annual conference. Is provides an in depth description of using Sequences in RAC and single instance Oracle and covers the administration, monitoring and tuning of issues relating to Sequence wait events.
This Article was written for publication in the OU EMEA Newsletter for winter 2009 and discusses the “Star Tranformation query feature used to optimise “Star Queries” in an Oracle Data Warehouse Database Schema.
Here is an article I co-authored with my friend and colleague from Oracle University Harald van Breederode which discusses the Oracle RAC Certified Expert Certification exam.