Oracle Performance Firefighting
by Craig Shallahamer

Get the book here



Craig Shallahamer's Blog

You were brought to this page based on an internet search and as a free service to Oracle DBAs.

The text below is an except from the book, Oracle Performance Firefighting, written by Craig Shallahamer of OraPub, Inc. Figures and tables are not included on this page, only their reference.
To order the book in either print or PDF form, click here.


©2009, 2010 by Craig Shallahamer. This is copyrighted material.
Please—Out of respect for those involved in the creation of the book and also for their familes, we ask you to respect the copyright both in intent and deed. Thank you.

-------------------------------

So, IMU nodes provide all the undo-related capabilities without any of the standard segment management overhead. Brilliant!

Another amazing feature of IMU is when it comes time to transform the in-memory undo into undo segment format, multiple IMU nodes can be collapsed or consolidated to minimize the amount of undo segment data. For example, suppose a transaction updates a buffer at three different times: T1, T2, and T3. Using traditional undo segments, this will cause three changes to the same buffer, complete with all the associated overhead with changing a buffer. With IMU in use, while three IMU entries are created, when it comes time to update the actual undo segment buffer, the three IMU nodes are collapsed to reduce the amount of undo. Plus the IMU nodes can remain in memory, so read-consistent queries can access the IMU nodes directly, instead of working with the traditional undo segments.

So as you can see, not only are IMU nodes holders of undo information, but they are also a mapping structure between a changed buffer and the undo. In a way, they intercept the traditional pointer from a buffer (located in the interested transaction list) to the undo block holding the change. When Oracle writes the IMU to the appropriate undo segment and flushes the IMU out of shared pool memory, the undo pointer is changed to point to the undo segment.

©2009, 2010 by Craig Shallahamer. This is copyrighted material.
Please—Out of respect for those involved in the creation of the book and also for their familes, we ask you to respect the copyright both in intent and deed. Thank you.


Know what's important before it's too late!

OraPub's
Performance Training

is like no other...





More Class Pics...
Get student testimonials!