Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 10046 trace: 'latch free' then 'db file seq. read' waits

Re: 10046 trace: 'latch free' then 'db file seq. read' waits

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Wed, 14 Jun 2006 13:10:03 GMT
Message-Id: <pan.2006.06.14.13.10.03.275176@sbcglobal.net>


On Wed, 14 Jun 2006 00:07:40 -0700, Spendius wrote:

> Argh... Forgot to say I'm dealing with an 8i DB, for which
> SQL> select name from v$latch where latch#=66;
> NAME
> ---------------------
> cache buffers chains

You need more cache buffer chains. I'm sorry, I forgot the parameters to create more chains. It's a long time for me since the last 8i access, at least 4 years. Oracle probably still has documentation on the Tahiti server, reference manual will tell you how to split buffer cache in more chains.

-- 
http://www.mgogala.com
Received on Wed Jun 14 2006 - 08:10:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US