Re: Overhead to consistent gets?

Hi,

> The particulars of the structures under a get are not as
> important as remembering that before walking that chain,
> the process has to obtain the latch on the chain. The

And with shared cache buffers chains latches in 9i (where platform supports 'em) this contention problem is releaved somewhat.

I think walking the chain can be done while holding the CBC latch in shared mode, allowing others to do the same. Reading index root blocks and single table hash cluster read access (where the "A" bit is set in block header) can also use this feature. This would be accounted in consistent gets - examination.

Tanel.

--
http://www.freelists.org/webpage/oracle-l