Skip Main Navigation
Page Content
This event has ended

Jonathan Lewis - All new 2-day "Oracle Mechanisms" webinar

Speak-Tech Webinars

Thursday, April 11, 2013 at 9:00 AM - Friday, April 12, 2013 at 4:00 PM (CDT)

Jonathan Lewis - All new 2-day "Oracle Mechanisms"...

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
Webinar 4 Tickets Ended $600.00 $0.00

Who's Going

Loading your connections...

Share Jonathan Lewis - All new 2-day "Oracle Mechanisms" webinar

Event Details

Jonathan Lewis is one of the world's foremost Oracle experts and Oracle Magazine's 2006 "Oracle Author of the Year." He is a member of the prestigious Oak Table Network, a network for Oracle Scientists.

Jonathan has long been a top presenter at IOUG, Oracle OpenWorld, UK Oracle User Group, and at User Groups everywhere. His very popular "Oracle Scratchpad" at jonathanlewis.wordpress.com is an excellent starting point for all things Oracle.

The cost of this webinar is $600..  This low price includes a free copy of your choice of Jonathan’s  “Oracle Core: Essential Internals for DBAs and Developers” (“Oracle Mechanisms” is based on this) or “Cost Based Oracle Fundamentals

The recording will be available to all attendees for free, unlimited playback for 30 days after the webinar.

Oracle Mechanisms – Agenda

This course is new for 2013 and is, in effect, a walk through the book Oracle Core. The two day event covers the core mechanisms of how the central portion of the basic database engine works. There are eight chapters in the book, which are reflected in the eight topic headings listed below; and the material presented in the course of the two days will follow this pattern.

Unlike previous courses, however,  which had a fixed timetable and were strictly set to four sessions of equal length each day, this course will have a flexible timetable where the number and duration of pauses will depend on the amount of interaction from the attendees. There will, however, be a lunch break in the middle of the day, and at least one break mid-morning and another mid-afternoon. Throughout the sessions we will always try to focus on the questions – how does knowing this information help me either make the application more efficient, or reduce the amount of maintenance work I need to do.

Topic 1

Overview.
A brief introduction to the principal files used in an Oracle database, the key processes and what they do with those file, and the way that Oracle uses memory.

 

Topic 2

Redo and Undo
The mechanisms that Oracle uses to change data, and reverse out change. Redo change vectors and undo records. How the redo and undo mechanisms allow Oracle to increase scalability and reduce blocking. Why we have redo log files but undo tablespaces. The three functions of undo.

 

Topic 3

Transactions and Consistency
The mechanisms that Oracle uses to change data, and reverse out change. Redo change vectors and undo records. How the redo and undo mechanisms allow Oracle to increase scalability and reduce blocking. Why we have redo log files but undo tablespaces. The three functions of undo.

 

Topic 4

Latches Mutexes and Locks
Why locks are different from latches and mutexes. Methods of using memory: arrays, pointers, hash tables and linked lists. Shared memory and the threat of lost updates. How latches and mutexes protect memory locations from concurrent overwrites. An example of the interaction of latches hash tables, and linked lists – the library cache. Locks as mechanisms for sharing and queueing. How queueing mechanisms lead to deadlocks. Internal structures used for locks. Some common lock types. A graphic explanation of v$lock. How Oracle also uses locks in the library cache.

 

Topic 5

The Buffer Cache
Layers of memory structures. Granules and buffer pools, buffers and buffer headers. Working data sets and the database writer(s). Buffer re-use and the LRU/Touch Count algorithm. Finding the right buffer – the cache buffers chains. Latching and pinning to protect shared memory. Reading data blocks into the buffer, and the creation and use of read consistent copies of blocks..

 

Topic 6

Writing and Recovery
The main write I/O activity. How DBWR and LGWR work individually, and how they co-operate. The various types of checkpoints and how they anticipate recovery scenarios and minimize the work needed to recover. Ancillary I/O activity – archiving, flashback logging, and change tracking – and how the range of recovery options affects the ongoing I/O load.

 

Topic 7

Parsing and Optimising
Note particularly that this chapter is not about the arithmetic of the cost-based optimizer, it is about the various structures in the shared memory that are manipulated due to a parse call. How much does Oracle need to know to “understand” an SQL statement, and how is this information handled.
What does the shared pool look like, and how does Oracle deal with loading and accessing all the pieces of information it needs to parse and optimize a statement. We start with memory granules to build the shared pool then consider the finer levels of granularity – the sub-pools and “durations”.
How does the dictionary cache work, how does the library cache work – and what is a cursor. What is the difference between a parent cursor and a child cursor. What is the difference between an “open” cursor, and a “pinned” cursor.

 

Topic 8

RAC and Ruin
A very brief look at how Oracle addresses the issues raised when multiple machines are all trying to share the same database. How can we share objects safely when the “shared memory” is distributed across several machines. The global resource directory; master resources and shadow resources and their role in crash recovery. A couple of special cases to consider when designing for RAC.

 

Have questions about Jonathan Lewis - All new 2-day "Oracle Mechanisms" webinar? Contact Speak-Tech Webinars

When

Thursday, April 11, 2013 at 9:00 AM - Friday, April 12, 2013 at 4:00 PM (CDT)


  Add to my calendar

Organizer

Speak-Tech Webinars

Speak-Tech is Minnesota-based and has organized webinars and seminars featuring the world’s leading Oracle experts for over 12 years.

Speak-Tech has organized over 100 training events for experts such as Jonathan Lewis, Tom Kyte, Cary Millsap, Tim Gorman, Gaja Krishna Vaidyanatha and David Kurtz, considered to be some of the world’s leading experts in Oracle Performance Tuning; Syed Jaffar Hussain, Oracle ACE Director who was awarded the Oracle Excellence Award for Technologist of the Year: DBA, 2011; Steven Feuerstein, considered to the world's leading expert in PL/SQL, Jim Czuprysnski and Matt Hart, all leading experts in their Oracle specialties.

  Contact the Organizer

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.