Fwd: Jonathan Lewis - all new "Oracle Mechanisms" Seminar & Webinar - April 11 & 12, 2013
- From: Tim Gorman <tim@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 08 Mar 2013 09:03:10 -0700
Jonathan is a frequent and extremely valuable contributor to this list,
as well as being a certified "individual of extraordinary abilities and
achievement" (a.k.a. holder of an O-1 visa) in the eyes of the US
Department of Homeland Security as well. This is an opportunity to
learn from someone who has painstakingly puzzled it all out, carefully
proven it out, and has an extraordinary ability to explain what he has
found.
I'm not a spokesperson, not a sales person, not compensated in any way;
just someone who has benefited from Jonathan's expertise and who is very
happy to share this.
Please see below if interested...
-------- Original Message --------
Subject: Jonathan Lewis - all new "Oracle Mechanisms" Seminar & Webinar
- April 11 & 12, 2013
Date: Thu, 7 Mar 2013 07:37:38 -0600
From: John Goodhue <johngoodhue@xxxxxxxxxxx>
To: 'Tim Gorman' <Tim@xxxxxxxxx>
**
*D**on't miss this opportunity to learn from the Best!*
*Speak-Tech is Proud to Present Jonathan Lewis's Newest Two-Day Seminar
& Webinar:*
*"Oracle Mechanisms"*
*Thursday & Friday, April 11 & 12, 2013 (**9**:00 a.m. to 4:00 p.m.
Central Time)*
The seminar will be held at Benchmark Learning
<http://www.benchmarklearning.com/ContactUs/Directions/Edina.aspx>__in
Minneapolis, MN (60 seats). The webinar will be a live Blackboard
Collaborate
<http://www.blackboard.com/platforms/collaborate/overview.aspx> of the
seminar (25 attendees).
The webinar's audio will be VoIP (no dial-in). You will see and hear
Jonathan present the same screens seminar attendees are viewing, from
the convenience of your home or officeand save you time andmoney.
**
*Cost: $600 */(Discounts apply for multiple attendees. Please call or
email)/**
**
This value price includes: A free copy of your choice of
Jonathan's "Oracle Core: Essential Internals for DBAs and Developers
<http://www.amazon.com/Oracle-Core-Essential-Internals-Developers/dp/1430239549/ref=sr_1_1?s=books&ie=UTF8&qid=1361110678&sr=1-1&keywords=jonathan+lewis+oracle>"
in hardcover or Kindle
<http://www.amazon.com/Oracle-Core-Essential-Developers-ebook/dp/B006C9EN1U/ref=sr_1_1?s=digital-text&ie=UTF8&qid=1362497093&sr=1-1&keywords=jonathan+lewis>
("Oracle Mechanisms" is based on this) or "Cost Based Oracle
Fundamentals
<http://www.amazon.com/Cost-Based-Oracle-Fundamentals-Experts-Voice/dp/1590596366/ref=sr_1_2?s=books&ie=UTF8&qid=1361110678&sr=1-2&keywords=jonathan+lewis+oracle>"
All seminar & webinar attendees will have free unlimited playback of the
webinar for 30 days.
Webinar: Click here <http://www.eventbrite.com/event/5612745874> to register
Seminar: Click here <http://www.eventbrite.com/event/5617911324> to register
*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
*Why writers don't block readers. Internals of the Undo Segment -- undo
segment headers and the transaction table. Chaining undo records in undo
blocks. Data segment headers and the Interested Transaction List.
Commits and the options for cleanout. Two forms of Oracle error
ORA-01555. The special handling for LOBs.
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.
Webinar: Click here <http://www.eventbrite.com/event/5612745874> to
register
Seminar: Click here <http://www.eventbrite.com/event/5617911324> to register
**
*Who and What is Speak-Tech?*
With 20 years of experience as an Oracle DBA in Minneapolis, MN, John
Goodhue is passionate about anything Oracle. He started Speak-Tech 8
years ago to increase the availability of high-quality expert Oracle
training at an affordable price and, without any competing ulterior
motives -- just expert Oracle training! John has organized 33 for
Jonathan Lewis; 22 for Steven Feuerstein and smaller numbers for Tom
Kyte, Cary Millsap, Tim Gorman, Gaja Krishna Vaidyanatha, David Kurtz,
Mike Swing and Matt Hart, all leading experts in their Oracle
specialties.John served as an Officer of the Twin Cities OUG for 10
years including 2 years as President, and is still a working DBA.
*Other Oracle Expert Seminars Speak-Tech has organized include:*
Steven Feuerstein, considered the world's leading expert in Oracle
PL/SQL, plus
Tom Kyte, Cary Millsap, Tim Gorman, Gaja Krishna Vaidyanatha, David
Kurtz, Mike Swing and Matt Hart, all leading experts in their Oracle
specialties.
**
*Cancelation Policy*:
A full refund will be provided if you cancel via email or phone by 5:00
pm CDT seven days before the seminar. Full credit toward a future
seminar of your choosing will be provided if you cancel via email or
phone by 5:00 pm CDT the day before the scheduled seminar.
Substitutions can be made at no charge at any time. If Speak-Tech
cancels a seminar, you will immediately receive a full refund.
John Goodhue
Speak-Tech Seminars
John.Goodhue@xxxxxxxxxxxxxx <mailto:John.Goodhue@xxxxxxxxxxxxxx>
Cell 612 203-6503
*Please reply to this email with "unsubscribe" in the subject line to
stop receiving all emails from Speak-Tech.*
--
//www.freelists.org/webpage/oracle-l
Other related posts:
