The Blog from the DBA Classroom

By: Joel Goodman

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.

>> Database Links MasterClass_2

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.

 

>> Database Links MasterClass Part 1

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.

>> The Benefits of Oracle Certification

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.

>> Installing Oracle  DBA 1.0

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.

>> Performing a DBA 1.0 to DBA 2.0 Upgrade

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.

>> Keep Your Sequences in Order

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.

>> Is There Too Much Action in Your Module

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.

>> Oracle DBA Certification Update 2008

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.

>> Managing Sequences in a RAC Environment

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.

>> Your Transformation is in the Stars

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.

>> Become an Oracle Certified Expert in RAC

8 Responses to “My Articles & Presentations”

  1. [...] Articles & Presentations by Joel Goodman A list of User Group presentations and articles that Joel 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. [...]

  2. [...] and presented at various user group meetings throughout Europe. (tags: oracle sql reference dba) Articles & Presentations by Joel Goodman A list of User Group presentations and articles that Joel wrote or co-authored and published in the [...]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 125 other followers

%d bloggers like this: