Oracle 9 implements sharable read latches
typically through an atomic 'compare and swap'
function, for some of the latches, in particular
the cache buffers chains latch, which should
reduce contention on systems with a very heavy
concurrent read requirement. (Unfortunately
I understand this excludes my HP platform,
but includes more recent Sun kit).
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Andrew Mobbs wrote in message <3Rk*mFdjp_at_news.chiark.greenend.org.uk>...
>Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:
>>
>>No doubt there is supporting code in the
>>loop somewhere for counting and timing
>>purposes, but pre-9, I believe the most
>>commonly used instruction was the
>>atomic 'test and set' instruction.
>
>"pre-9" ? What happens at 9?
>
Received on Thu Mar 14 2002 - 17:05:01 CST
