RE: CBC Latch contention in 10g

Perhaps fanfare was too strong a word. I was greatly encouraged by what I read about CBC latch sharing for reads in Cary's "Why You Should Focus on LIOs Instead of PIOs" and Richmond's "Oracle Wait Interface:..."

Regards,

John Smiley

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jonathan Lewis
Sent: Thursday, October 21, 2004 11:38 AM To: oracle-l_at_freelists.org
Subject: Re: CBC Latch contention in 10g

I don't know if there is any published material on this - I think I got the important bit of it from Steve Adams' masterclass.

It's likely that the sharable cache latch used some of the time is better than never having it at all - and Oracle does keep finding new ways to (a) reduce the latch acquisition, and (b) switch to single latch reads anyway, so scalability does keep improving.

Where did you see a fanfare about sharable latches, I didn't spot it. I'd be interested to see how it was presented.

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated Sept 19th

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 21 2004 - 13:22:27 CDT