Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: wait events
Hi
If you don't specify at least the event's name it will be difficult to give you a tip...
Chris
"Azar" <consult_me_1st_at_yahoo.com> wrote in message
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=