Who should attend?

• Experienced DBAs should attend all three sessions, but only DBAs should attend Troubleshooting & Tuning.
• Experienced Developers should attend the Writing Optimal SQL and Explain Plan seminars.

What will they learn?

• The difference and the strategies.
• Why tuning is hard but trouble-shooting is easy.
• Key targets, indicators and mechanism for producing a well-tuned system on day one.
• Strategies for dealing with badly performing systems after go-live.
• Some of the most commonly occurring issues that affect performance after a system has gone into production.
• Methods for spotting them, measuring their impact and fixing them.
• Getting into the habit of pre-emptive analysis and pro-active fixing.
• Methods, workarounds, dirty tricks and parameters for dealing with classic performance problems.
• How to carefully examine costs, risk, and benefits.
• Familiarity with the key dynamic V$ and X$ performance views.