Re: Cache buffer chain problem

From: Frank <frankbo_at_interaccess.nl>
Date: Fri, 15 Sep 2000 16:59:09 +0200
Message-ID: <8ptdg2$61s$1@porthos.nl.uu.net>

Hmmm,

similar problem over here, waits for "sequential db read" forever... for a single block
off a (large 4.5mil) table. Any idea's? Happens quite randomly.

--
Frank
Connor McDonald <connor_mcdonald_at_yahoo.com> schreef in berichtnieuws
39BE12DD.7FB1_at_yahoo.com...


> robertchung0909_at_my-deja.com wrote:

> >

> > We have a server that is suddenly causing some problem.  A job that

> > used to finish in about 3-4 seconds sometimes takes 5 minutes to

> > complete.  This problem appears and disappears randomly.  We found when

> > the job is taking long, it mostly sits idle waiting on "Cache Buffer

> > Chain".  Has anyone seen this behavior?  What should we do to alleviate

> > this problem?  We are using Oracle 7.3.4 on RS/6000.  Thank you in

> > advance.

> >

> > Sent via Deja.com http://www.deja.com/

> > Before you buy.

>

> Typically caused by a runaway process or a bad SQL, so you're

> agressively getting a small number of blocks over and over...Look at

> p1,p2,p3 of your waits to identify which block,file and thus object and

> work from there...

>

> HTH

> --

> ===========================================

> Connor McDonald

> http://www.oracledba.co.uk

>

> We are born naked, wet and hungry...then things get worse

Received on Fri Sep 15 2000 - 09:59:09 CDT