Advanced SQL Tuning Tips and Techniques with Dan Hotka 10 - 11 May 2010, London May 9, 2010

Join Oracle expert Dan Hotka as he explores how understanding execution with an Explain Plan will help you retrieve the right data from your Oracle database.

An Explain Plan shows how a relational database will access the data. Starting with a comprehensive overview of the Oracle architecture, Dan will illustrate how SQL and applications can take advantage of the computing environment and how Oracle arrives at an execution plan - the Explain Plan.

Learn, through Dan's examples, how various coding techniques can ensure your SQL runs at maximum performance in Oracle database environments - now and in the future. Understand the role of indexes - and the decision process Oracle uses when selecting whether to use indexes or not. See how to tell which indexes are being used, and when.

Find out about free tuning aids such as the Oracle Trace Facility, Stats Pack, and the newer Trace Analyzer. Apply the information you've learnt in a discussion about finding problem SQL using scripts and additional information in the V$ and X$ dictionary views. All scripts used in this seminar will be made available to you.

Your seminar will conclude with a discussion on some Oracle 10g new features that might be causing performance issues.

Topics:

* Understanding Explain Plans
* Controlling Explain Plans
- Using Hints
- Using Coding Techniques
* Index Utilization
* Index Monitoring
* Identifying Poor Indexes
* Working with Oracle Tuning Tools
- Stats Pack/AWR
- Oracle Trace
- Trace Analyzer
* Finding Problem SQL using Scripts
- Oracle Working Too Hard
- Oracle Not Allowed to Work
* Oracle10g Performance Issues and Solutions
- When migrating from earlier versions of Oracle RDBMS
* Oracle10g Performance Issues and Solutions
- When migrating from earlier versions of Oracle RDBMS

Official Website: http://cli.gs/zQWgsa