Re: wait events

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Tue, 20 Jul 2004 01:30:32 GMT
Message-ID: <Xns952BBC48A5BBSunnySD@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. Received on Mon Jul 19 2004 - 20:30:32 CDT