UK Oracle User Group


UKOUG Database SIG

« Return to event

Time: 3:45 PM - 4:00 PM

Track: Track 1

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.

Presented by

  • Jonathan Lewis, J L Computer Consultancy

Top