Re: delayed block cleanout (?) for active tx

> In short, every time this select statement is accessing the block, block is
> cleaned out and updated with current SCN, even though there is nothing to be
> cleaned out. Essentially, confirming what you stated in the first place
> "null" cleanout. I don't know why though.

Thanks Riyaj,

your great analysis convinced me completely.

About the "why", all we know is that updating the csc scn avoids another block cleanout (and visit to the rollback segments) if the block is requested at the same scn. The only scenario where it could make a big difference is e.g. for the root block of the inner table index on a nested loop; maybe it checks the current block (tries to cleanout it) before searching for the CR copy everytime.

But I'm only guessing here.

Thanks again for your explanation,
Alberto

--
Alberto Dell'Era
"the more you know, the faster you go"
--
http://www.freelists.org/webpage/oracle-l