Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 10046 trace: 'latch free' then 'db file seq. read' waits
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.comReceived on Wed Jun 14 2006 - 08:10:03 CDT