Re: Cache buffer chain problem

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