Re: need help on statspack report, Parse CPU to Parse Elapsd %

From: VC <boston103_at_hotmail.com>
Date: Tue, 09 Mar 2004 14:58:08 GMT
Message-ID: <4Yk3c.220587$jk2.757032@attbi_s53>

Hello Joe,

"Joe" <yung103_at_netvigator.com> wrote in message news:c2khir$3v123_at_imsp212.netvigator.com...
> Srivenu,
>
> thanks a lots
>
> Joe
>
>
>
> "srivenu" <srivenu_at_hotmail.com> ???
> news:1a68177.0403072237.7c720258_at_posting.google.com ???...
> > Joe,
> > This SQL can help you find out the Enqueue for which most waits have
> happended.
> > SELECT ksqsttyp "Lock",
> > ksqstget "Gets",
> > ksqstwat "Waits"
> > FROM X$KSQST
> > where KSQSTWAT>0
> > order by 3
> >
> > regards
> > Srivenu

Actually, you already know what enqueues you've experienced from your statspack report:

Enqueue Gets Waits
---------- ------------ ----------

TX              121,080         18
UL               10,975          2

TX -- is a row-level(transaction) lock
UL -- is a user lock acquired via the dbms_lock package.

Now, you need to determine who's blocking whom.

VC Received on Tue Mar 09 2004 - 08:58:08 CST