Jonathan Lewis Oracle Explain Plan Seminar


		Full day seminars by top Oracle experts

This seminar sold out the last time it was at Benchmark (September 13, 2010) so sign up early!

Jonathan will present his one day "Explain Plan" on Wednesday, August 15th at Benchmark Learning.

One of the critical skills for tuning SQL lies in understanding what is happening, and what is possible. Oracle gives you several tools for examining (or predicting) the execution path for a query. In this tutorial we look at the available options, examine their strengths and weaknesses, and learn how easy it is to understand what an execution plan is telling you.

Each attendee will receive a free copy of Jonathan's new book "Oracle Core: Essential Internals for DBAs and Developers" a $31.91 value.

Complimentary Breakfast Provided

Status:

Completed

Speaker:

Jonathan Lewis

Location:

Benchmark Learning
4510 West 77th Street
Suite 210
Edina, MN 55435
952.896.6800

Sponsor:

None

Date:

Aug 15, 2012

Price:

$300.00 for members ($350.00 for non-members)

Agenda

Speaker Info

Sponsor Web

Waiting List

Driving Directions

Nearby Hotels

Registration Closed

Who should attend?

Experienced DBAs and Developers. This is a fast-paced class and attendees should have a good understanding of Oracle.

What will they learn?

The different methods of generating execution paths, from autotrace to explain to v$sql_plan_statistics_all in great detail and how to choose the right method.
How to read execution plans -no matter how complex - in a fashion that can be described in just two steps.
The various omissions and errors that lead to the wrong conclusion when trying to understand how a query might run.
Extending understanding to features such as distributed joins, parallel execution, and partitioned tables.

	Calendar

There are no seminars on the

calendar at this time.

View all Seminars