Next seminar dates and locations
All training is delivered by Tanel Poder We also offer private corporate training and seminars. If you have further questions, then feel free to send me an email: tanel@tanelpoder.com Advanced Oracle SQL TuningSeminar overviewThis seminar is entirely about making Oracle SQL execution run faster and more efficiently, understanding the root causes of SQL performance problems and Cost Based Optimizer misbehavior.You will learn the full range of techniques for SQL tuning starting from optimizer stats placement strategy all the way to advanced topics such as comprehensive SQL hinting and CBO’s estimated row count adjustments. We start from the low level fundamentals, explaining how exactly Oracle SQL plan execution works, what are the main factors affecting query performance and how to systematically diagnose and fix SQL performance problems. Some SQL performance problems cannot be cured by just an easy change to application code or optimizer stats, so a significant part of this seminar also concentrates on good database design and indexing practices. Finally, this class is not about a limited list of "tips and tricks", instead it will give you the knowledge and tools for systematic tuning and troubleshooting SQL of any complexity.
LinksAdvanced Oracle Troubleshooting v2.0
This is the new version 2.0 of the Advanced Oracle Troubleshooting seminar which Tanel has delivered all around the world. LinksPartitioning and Parallel Execution for Performance
|
|
|
Oracle Training and Seminars |