Re: Data Block Cleanup??

: : My pet theory is that Oracle is choosing this time to remove the
: : old transaction entry (used by the previous update to the block and
: : not removed on commit because of the obvious performance impact this
: : would have).
 

: We experienced the same thing. An ORACLE field technician told us this
: is known as a lazy cleanup. The block header information is not "cleaned
: up" until the select after the insert or update that caused it to be
: updated. He did not say exactly what in the header was being cleaned
: up, but the old transaction entry would seem to be a reasonable guess.

To my information, this is completely right.

• Joerg Plewe