Re: session wait stats

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 02 Jul 2007 06:26:32 -0700
Message-ID: <1183382792.726306@bubbleator.drizzle.com>

newhorizon wrote:

>>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

What is the specific performance issue you are experiencing with your system such that you are not meeting your SLA with your customers?

Are you familiar with what these events indicate?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Mon Jul 02 2007 - 08:26:32 CDT