Back To Schedule
Friday, April 19 • 10:30am - 11:15am
10053 trace files - Mostly Harmless (P11)

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

The trace files generated by setting event 10053 are usually considered some of the longest and least understandable that Oracle generates. However, they are sometimes very useful in understanding why the Cost Based Optimizer has produced what appears to be a bad execution plan and recent versions have become more readable. This presentation will give you a taste of the trace file contents and encourage you to use them when analysing SQL performance issues. - What they are and how to generate them- Why they are useful and mostly harmless- Walk-through of example trace files to highlight overall structure and useful sections- Examples of problems that you can identify using 10053 trace files”

avatar for Doug Burns

Doug Burns

Bayvale Consulting Services Ltd
Doug is an Oracle 9i Certified Professional DBA with over 20 years experience in a wide range of environments and has used Oracle versions 6 through to 11g on a number of different operating systems, including RAC, OEM Grid Control and ASM. He currently works as an Oracle specialist... Read More →

Friday April 19, 2013 10:30am - 11:15am CEST
1. Auditorium 1 Color Magic