The workshop begins with an in-depth look at statistics and statistics maintenance, a challenge all DBAs must face in order to prevent sub-optimal execution plan. This presentation includes information on the features introduced in Oracle Database 11g to improve the quality and efficiency of statistics gathering, as well as strategies for managing statistics in various database environments. These strategies include how to use dynamic sampling and when, and how, to manually set statistics directly versus collecting them.
The workshop continues with a detailed explanation on how to interpret an execution plan. Each aspects of an execution plan is examined, from cardinality estimates to parallel execution and you will learn what information you should be gleaming from the plan and how it affects the execution.
After lunch the workshop focuses on the process of analyzing and resolving the most common SQL execution performance problems including, poor cardinality estimations, bind peeking issues, selecting the wrong access method and more. With clear how-to examples you will learn how to identify and quickly resolve these issues and develop a methodology to prevent them in the future.
- Introduction to the Oracle Optimizer and in-depth discussion on statistics
- Explaining the EXPLAIN PLAN
- Detailed look at what can cause an execution plan to go wrong
- Guide to tuning SQL statements
Tom Kyte is a Senior Technical Architect in Oracle’s Server Technology Division. Before starting at Oracle, Tom worked as a systems integrator building large-scale, heterogeneous databases and applications, mostly for military and government customers. Tom spends a great deal of time working with the Oracle database and, more specifically, working with people who are working with the Oracle database. In addition, Tom is the Tom behind the AskTom column in Oracle Magazine, answering people's questions about the Oracle database and its tools (http://asktom.oracle.com/). Tom is also the author of Expert Oracle Database Architecture (Apress, 2005), Expert One on One Oracle(Wrox Press, 2001/Apress 2004), Beginning Oracle Programing (Wrox press, 2002/Apress 2004), and Effective Oracle by Design (Oracle Press, 2003). These are books about the general use of the database and how to develop successful Oracle applications.