This course will cover a variety of SQL statement tuning issues, controlling the Oracle optimizers, tips and techniques for good relational/application design to take advantage of Oracle's b-tree indexing structures, and advanced topics such as Oracle Trace, Stats Pack/AWR, and a variety of parameter settings that make a big difference to Oracle-based applications. One-forth of this workshop focuses on monitoring Oracle RDBMS and SQL via the v$ tables. This course is packed full of scripts to discover a variety of issues.
This course also covers new features in Oracle10g /11g that will have an affect on your migrated applications. The focus of this tuning course is to cover advanced SQL performance tuning topics for those Oracle professionals that already have a SQL tuning background. This course is perfect for DBA’s that need the additional background to solve the more difficult problems.
More info and how to register here: http://bit.ly/DanHotka_Istanbul_Sep2011
Added by giacodrescu on June 22, 2011