Ask Tom Live: A 2-day Seminar with Tom Kyte

Description:

This seminar contains all new material, and Tom is excited about presenting it to a European audience for the first time. Presented in the same fashion as he answers questions on the AskTom website, Tom Kyte will present nine seminar topics relevant to DBA and Developers alike. Every session is aimed at both audiences - none are solely for one group or the other.

The top 10 - no 11 - new features of Oracle Database 11g:
This session will focus on eleven new, high impact features of Oracle Database 11g and what they mean to you the developer or DBA.

All about binding:
We'll briefly overview why it is extremely important with regards to performance, scalability and even security but quickly move into topics such as: Do I always want to bind? What is bind variable peeking? Is it good or evil in disguise or a bit of both?

Materialized Views, Caching:
In this session we’ll explore what a materialized view is, how they work, when we might use them, and various useful ‘techniques’ you need to know in order to make the most of them.

Effective Indexing:
We all know that “indexes are good”, but what kind of index is appropriate, and under what circumstances? How does the type of index affect us? What are the considerations you want to be thinking of when coming up with your indexing scheme.

Storage Techniques:
This session will look at the physical structures available to us, discuss when to use each. Techniques such as clustering, index organized storage, partitioning and compression will be investigated.

Reorganizing objects:
when and how – We will discuss the times when a reorganization or rebuild is relevant, how to measure what you’ve done (to verify that the work performed did something useful!), and the best techniques for performing a reorganization of data.