Re: CBC Latch contention in 10g
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: "'Oracle-L (E-mail)'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 20 Oct 2004 01:08:28 +0300
> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
