Re: Overhead to consistent gets?
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: <kevinc@xxxxxxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 12 Jan 2006 13:54:15 -0600
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
