wait events

From: Azar <consult_me_1st_at_yahoo.com>
Date: 19 Jul 2004 08:36:17 -0700
Message-ID: <5fec53f1.0407190736.14449c77@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

Received on Mon Jul 19 2004 - 10:36:17 CDT