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.
PleaseOut 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.
-------------------------------
* If a failure occurs during a read-consistent operation, it simply stops without any committed data loss.
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.
©2009, 2010 by Craig Shallahamer. This is copyrighted material.
PleaseOut 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.
|