Re: Lot of row cache/library pin

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Sat, 29 Nov 2008 19:00:57 -0800 (PST)
Message-ID: <8d28e62e-0669-476f-8d2d-d56fa529076c@v42g2000yqv.googlegroups.com>


On Nov 29, 9:03 am, "astalavista" <nob..._at_nowhere.com> wrote:
> Hi,
>
> I have a database 9.2.0.6, with the wait events below:
>
> Top 5 Timed Events
> ~~~~~~~~~~~~~~~~~~                                                     %
> Total
> Event                                               Waits    Time (s) Ela
> Time
> -------------------------------------------- ------------ ----------- --------
> row cache lock                                     37,587      87,406
> 63.12
> library cache pin                                   6,565      17,853
> 12.89
> enqueue                                             5,255      15,093
> 10.90
> CPU time                                                       11,337
> 8.19
> db file sequential read                         1,880,609       2,261
> 1.63
>
> It is a DSS database used for a trainning
> so a lot of same select are done at the same moment
> and we have a slow  response time.
>
> What can I do to improve response time ?
> Thanks in advance

Let me guess ... you have an app doing select's for update that isn't immediately doing commits or rollbacks ... even better ... the app goes thru tables that don't have rows that limit the number of sessions trying to update them all at the same time ... Received on Sat Nov 29 2008 - 21:00:57 CST

Original text of this message