UK Oracle User Group

UKOUG Database SIG

« Return to event

Time: 3:15 PM - 4:00 PM

Track: Track 1

The performance questions that come up on the internet say things like: "This batch job is taking too long, should I increase the db_file_multiblock_read_count?"; and you wonder why that idea was seen as a possible 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 troubleshooting:

First - what 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.

Three point takeaway on troubleshooting:
Recognising the right problem to tackle
Using the right tools to identify the critical issue
Using all the information that Oracle makes available to help you

Presented by

  • Jonathan Lewis, JL Computer Consultancy

Send this page to your friend

Your details

Your friend's details


Please click the box below to indicate you are a human rather than an automated system completing this form.