Ask Tom: Oracle University On-Line Training with Tom Kyte – LVC

Online Event

Oracle University is proud to present our online Celebrity Seminars series. This is a unique opportunity to attend an online Seminar with one of Oracle’s most experienced Database Gurus consisting of two, consecutive, in depth four-hour sessions. (Total: seven and half hours) Join us for this novel and original Celebrity Seminars virtual series right from your desktop. Each training session gives you the opportunity to gain deep insight into Database.

These highly advanced sessions will cover the following:

Monday, 18 January 2010 2:00 PM – 6:00 PM CET

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? (Surprisingly, the answer is no.) What is bind variable peeking? Is it good or evil in disguise or a bit of both? So the developers don’t bindis cursor_sharing=force/similar appropriate system wide? (Emphasis will be on the reasons why setting cursor sharing at the instance level is not such a good idea.) What is the real difference between cursor_sharing=force/similar and which should we use under what circumstances? The presentation will be practical, with many examples and hard numbers you can use in your day-to-day work.

Reorganizing objects

A hotly debated topic is “do I need to reorganize/rebuild indexes and tables”. 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.

Tuesday, 19 January 2010 2:00 PM – 5:30 PM CET

Storage Techniques

How data is stored on disk by Oracle directly affects the speed at which we can retrieve that data (and modify it, and create it and so on). This session will look at the physical structures available to us; discuss when to use each (and when not to!). Techniques such as clustering, index organized storage, partitioning and compression will be investigated.

Efficient PL/SQL

Why and how to use PL/SQL to it’s greatest effect

Event Organizer: Oracle University

Register Online