session wait stats

From: newhorizon <mehmeteser_at_gmail.com>
Date: Mon, 02 Jul 2007 06:10:53 -0700
Message-ID: <1183381853.587578.179210@k29g2000hsd.googlegroups.com>

>From the v$session_wait_history I have a high amount of event waits
for the following two event types.
What could be the main reason for that ?

select event,sum(wait_time) from v$session_wait_history

     group by event
     order by 2 desc;


EVENT	SUM(WAIT_TIME)

SQL*Net message from client	4543124
rdbms ipc message	1466580
Streams AQ: waiting for time management or cleanup tasks	266993
Streams AQ: qmn slave idle wait	27340


______________________________________________________________________________

select * from v$version;

BANNER Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Linux: Version 10.2.0.3.0 - Production NLSRTL Version 10.2.0.3.0 - Production Received on Mon Jul 02 2007 - 08:10:53 CDT