Oracle 10g Application Tuning Workshop

This class will teach Oracle developers and DBAs how to performance tune applications for an Oracle 10g database server. Good design techniques, programming techniques and performance tuning practices will be emphasized throughout the course. Students will learn how Oracle processes SQL statements and makes decisions on how to execute SQL statements. The first day of class helps the students develop a tuning methodology and develop an understanding of the Oracle architecture. The second day will focus on tuning SQL statements and the Oracle tools used to tune SQL statements. The last day will focus on customizing an Oracle session for different types of environments and how to optimize applications OLTP and DSS. This class is taught in a workshop environment to maximize the time students spend tuning SQL code in the class. Understanding how to leverage the cost-based optimizer is the focus of the class. Developers will also be introduced to SQL tuning tools available to DBAs.