Re: CBC Latch contention in 10g

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Wed, 20 Oct 2004 01:08:28 +0300
Message-ID: <04f301c4b628$2a348a90$ec879fd9@porgand>

> I'm seeing large numbers of CBC latch waits when many sessions (20-40) run
> the same SELECT statement simultaneously (I can peek at v$session_wait and
> catch this many sessions waiting on latch free: cache buffers chains for
the
> same sql_id).

Which platform are you on? HP-UX?

Did you have 9i running on the same box before without problems?

What are the values for 'shared hash latch upgrades%' statistics?

Tanel.

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

Received on Tue Oct 19 2004 - 17:04:05 CDT