Loading…
This event has ended. Create your own event → Check it out
This event has ended. Create your own
Welcome to the HOUG Spring 2016 Schedule
View analytic
Thursday, April 28 • 1:15pm - 2:30pm
A Close look at the 10053 Cost-Based Optimizer Trace

Sign up or log in to save this to your schedule and see who's attending!

Dan pulls from his vast knowledge of SQL tuning topics to share with you the details and benefits of the 10053 CBO trace. The CBO trace answers the question of why did I get this explain plan. The CBO trace also shows all explain plan options considered. You should leave this presentation with a better understanding of how the CBO actually works.
Dan will cover:· Review how the CBO arrives at an Explain Plan· How to start/stop the CBO Trace complete with scripts· Content Details includingo Query Transformationo Actual SQL submittedo Machine and object statisticso ALL init.ora settingso Purmutation process reviewo Hint utilization

Speakers
DH

Dan Hotka

Dan Hotka


Thursday April 28, 2016 1:15pm - 2:30pm
Nebraska Auditorium

Attendees (12)