Exclusive 2-day Seminar on Advanced SQL Tuning Tips and Techniques with Dan Hotka
16 – 17 August 2010 in Delhi
18 – 19 August 2010 in Bangalore
The course starts out with a complete overview of the Oracle architecture so students can get an understanding how their SQL and applications can take advantage of the computing environment. This seminar goes into detail on how Oracle arrives at an execution plan, the explain plan.
Dan illustrates various coding techniques that insure the SQL runs at maximum performance in the current and future Oracle database environments. Indexes are closely examined as well. The internal structure is discussed as well as the decision process Oracle uses when selecting whether to use indexes or not. Dan will illustrate how to tell which indexes are being used. Dan illustrates various free tuning aids such as the Oracle Trace Facility, Stats Pack, and the newer Trace Analyzer.
This seminar then uses this information in a discussion on finding the problem SQL using scripts and additional information in the V$ and X$ dictionary views. All scripts illustrated in this seminar will be made available to the attendees. The seminar concludes with a discussion on some Oracle10g new features that might be causing performance issues.
* Understanding Explain Plans
* Controlling Explain Plan
o Using Hints
o Using Coding Techniques
* Index Utilization
* Index Monitoring
* Identifying Poor Indexes
* Working with Oracle Tuning Tools
o Stats Pack/AWR
o Oracle Trace
o Trace Analyzer
* Advanced SGA Topics
o Buffer Cache
o Library Cache
o Additional Stats Topics
* Finding Problem SQL using Scripts
o Oracle Working Too Hard
o Oracle Not Allowed to Work
* Oracle10g Performance Issues and Solutions
o When migrating from earlier versions of Oracle RDBMS
Seats are limited for this seminar – so book your seat early!
email: [email protected]
Dan Hotka is a Training Specialist and an Oracle ACE Director who has over 32 years in the computer industry, 27 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Danâ€™s latest book is the TOAD Handbook by Pearson. He is also the author of SQL Developer Handbook by Oracle Press, SQL Developer Handbook by Oracle Press, Oracle9i Development By Example, and Oracle8i from Scratch by Que and has co-authored 7 other popular books including the Database Oracle10g Linux Administration by Oracle Press. He is frequently published in Oracle trade journals, and regularly speaks at Oracle conferences and user groups around the world.
Visit his website at www.DanHotka.com