« 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
- Jonathan Lewis, JL Computer Consultancy