/06 Wed PM 11:29:23 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: why does block cleanout incur redo?
It's because flush doesn't mean what you probably think. During a
delayed block cleanout, Oracle updates a block's transaction table
(ITL). Any time a block gets
My understanding of block cleanout is that oracle
is flushing transaction information of already committed transactions from the
buffer cache. This can happen in selects, when 10% of the buffer cache is filled
with 'lists' if blocks involved in transactions, or with dml.
i dont understand
, 2003
9:34 PM
To: Multiple recipients of list
ORACLE-L
Subject: why does block cleanout
incur redo?
My understanding of block cleanout
is that oracle is flushing transaction information of already committed
transactions from the buffer cache. This can happen in selects, when 10% of the
buffer cache
:
[EMAIL PROTECTED] Subject: Re: RE: why does block
cleanout incur redo?
ity.com