Upcoming event: Kscope 13
By Maria Colgan-Oracle on May 02, 2013
Kscope 13, is the annual conference of the Oracle Development Tools User Group, taking place June 23 - June 27, in New Orleans. This is a great conference for Oracle developers and architects, offering some of the best content by renowned experts.
I am lucky enough to be involved in five sessions this year around the Oracle Optimizer and performance. Below are details on the sessions I will be presenting. I hope you have an opportunity to check out some of these sessions if you plan to attend the conference!
- Sunday, June 24st at 2:00pm What's new with the Optimizer
This session is part of the Database and Developers SIG that is happening on Sunday. In this session I will demonstrate what you can expect from the latest version of the Optimizer and provide details on how the different plan influencing features work together.
- Monday, June 24th at 9:45 am Optimizer Hints: Tops Tips for Understanding and Using Them
I am kicking things off early on Monday morning with this session on Optimizer hints. I plan to discuss in detail how Optimizer hints are interpreted, when they should be used, why they appear to be ignored and what you can do if you have inherited a hint ridden application.
- Wednesday June 26th at 1:45 pm Hands-on Training: How to Prevent Suboptimal Execution Plans
Come join me and get your hands dirty with this great Optimizer lab where you will have an opportunity to analyze and resolve some of the most common SQL execution performance problems in 4 detailed exercises. The VM for this lab can be downloaded here.
- Wednesday June 26th at 3:00 pm Oracle Optimizer: An Insider's View of How it Works
In this session I will discuss how with each new release the Optimizer evolves as we strive to find the optimal execution plan for every SQL statement and will provide a detailed explanation of how the latest version of the Optimizer works and the best ways you can influence its decisions.
- Thursday June 27th at 9:45 am Exadata & the Optimizer The untold story
Since the introduction of the Exadata platform, 4 years ago, people have been asking how should they tune for it. This session explains, with the use of detailed examples, how the Optimizer behaves on Exadata and what information you should supply to ensure an optimal execution plan is selected every time.