Oracle Scratchpad

Public Appearances


23rd Jan 2018 Birmingham, UK: I’ll be speaking at the UKOUG Database SIG at Blythe Valley Park with the topic: “Back to Basics with Trouble-Shooting”.

The performance questions that come up on the Internet often say things like: “This batch job is taking too long should I increase the db_file_multiblock_read_count?”; and you are often left wondering why such a specific idea was seen as an appropriate way to address the time spent in the batch. It’s too easy to fall into the trap of trying to fix the problem without really knowing what the problem is and where to focus the attention.

This presentation outlines a mental pattern for trouble-shooting:

First – what type of problem are we trying to solve
Second – why has that come to our attention as a problem
Third – what tools do we use to get better information about the problem
Finally – what are we likely to see and how do we interpret it.

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

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

You are commenting using your 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

Powered by