Re: wait events

From: Yong Huang <yong321_at_yahoo.com>
Date: 21 Jul 2004 08:13:48 -0700
Message-ID: <b3cb12d6.0407210713.6b39352f@posting.google.com>

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<Xns952BBC48A5BBSunnySD_at_68.1.17.6>...
> consult_me_1st_at_yahoo.com (Azar) wrote in
> news:5fec53f1.0407190736.14449c77_at_posting.google.com:
>
> > Hi,
> >
> > I have a 8.1.7.4 Oracle APPS 11i instance. Its a OLTP environment with
> > about 130 users running on solaris 2.8 with 3 gig of ram and 6x400
> > CPU'S.
> > I found the following events. Any feedback would be appreciated.
> >
> > thanks
> >
> > SQL> select p1,p2,p3,SECONDS_IN_WAIT from V$SESSION_wait where
> > WAIT_TIME > 0;
> >
> > P1 P2 P3 SECONDS_IN_WAIT
> > ---------- ---------- ---------- ---------------
> > 100 0 0 0
> > 1952673792 1 0 3074
> > 1952673792 1 0 1499
> > 1952673792 1 0 15233
> > 1952673792 1 0 17
> > 1952673792 1 0 1916
> > 1952673792 1 0 5149
> > 1952673792 1 0 3532
> > 1952673792 1 0 4300
> > 1952673792 1 0 1590
> > 1952673792 1 0 1619
>
> So?
> Too little information.
> I suspect these are "SQL*Net" waits and may or may not be significant.

Indeed he should show the event column. If P1 is 1952673792, then P1raw is 74637000. 74-63-70 is t-c-p's ascii code. So you're right. They're SQL*Net messages. The first line with P1=100 is something hard to identify this way.

Yong Huang Received on Wed Jul 21 2004 - 10:13:48 CDT