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.
-------------------------------
<p>Fortunately, the transaction numbers do match! The undo in undo block 2,70 was changed at SCN time 12340, which is after our query started, so we apply the undo to our CR buffer. The next undo link is empty, so there is no more undo to consider applying.
p><p>Referring back to our ITL entries, there are no more ITLs to consider, so we have completed our block clone. Any server process can now access CR buffer 7,678 consistent at time 12330.
p><p>It should now be obvious why ITLs are so important and that Oracle's read-consistent model, while extremely powerful and necessary and efficient, is still relatively expensive because it has the potential to consume a lot of CPU and IO, slowing application response time. Oracle is very aware of this, and in Oracle Database 10g Release 2, it started using in-memory optimized structures to temporarily store undo information. These objects are not segments and are therefore not subjected to segment-related overhead like CBC and LRU chain activity. In memory, undo is stored in the shared pool, which is covered in Chapter 7.
p>
©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!
|
