Northern California Oracle Users Group

SQL Optimizer One-Day Master Class with Tom Kyte

  • 20 Nov 2013
  • 8:30 AM - 5:30 PM
  • Network Meeting Center @ TechMart, 5201 Great America Parkway, Santa Clara, CA 95054
  • 0


Includes a copy of Tom Kyte’s book
Wine-and-cheese reception to follow

Oracle evangelist Tom Kyte

Since its introduction in Oracle 7, people have been fascinated and intimidated by the Cost-Based Optimizer and the statistics it relies on. It has long been felt that the internals of the Optimizer were shrouded in mystery and that a degree in wizardry is required to be able to make it do the right thing. This one day workshop will explain the fundamentals of the cost based Optimizer and the statistics that feed it, as well as providing a methodology for diagnosing and resolving SQL execution performance problems.

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.

08:3009:00 Registration and Continental Breakfast

09:00–10:30 Introduction to the Oracle Optimizer and in-depth discussion on statistics

10:30–10:45 Break

10:45–12:15 Explaining the EXPLAIN PLAN

12:15–13:15 Lunch

13:15–14:45 Detailed look at what can cause an execution plan to go wrong

14:45–15:00 Break

15:00–16:30 Guide to tuning SQL statements

16:30–18:00 Wine-and-cheese reception sponsored by Fusion-io
November 20, 2013, 8:30 am to 5:00 pm with a one-hour lunch break. Wine-and-cheese reception from 5:00 pm to 6:00 pm.
Member early-bird price $299
Member regular price $399
Non-member early-bird price $399
Non-member regular price $499
Network Meeting Center @ TechMart
5201 Great America Parkway
Santa Clara, CA 95054

Refund and cancellation policy: Refund requests will be accepted until October 22. NoCOUG reserves the right to cancel the event at any time and refund all payments. NoCOUG reserves the right move the event to a smaller or larger venue depending on the number of registrations.

Powered by Wild Apricot Membership Software