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

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 14 Jun 2006 07:22:09 -0700
Message-ID: <1150294929.113090.285580@g10g2000cwb.googlegroups.com>

Mladen Gogala wrote:
> 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.

Conceivably possible but more likely it's bad SQL or some kind of strange optimizer derived access pattern.

What's the point in taking a wild stab in the dark?

To the OP: Could you post the SQL that is involved and the relevant explain plan? Received on Wed Jun 14 2006 - 09:22:09 CDT