Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: session wait stats

Re: session wait stats

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: Mon, 02 Jul 2007 06:36:31 -0700
Message-ID: <1183383391.133959.228760@k29g2000hsd.googlegroups.com>


On Jul 2, 9:10 am, newhorizon <mehmete..._at_gmail.com> 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

Google search:
  site:oracle.com idle event wait

First link returned is this one:
http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10752/instance_tune.htm

Take a look at the list of Idle Wait Events. Outside of a 10046 trace, the presence of such wait events should likely be ignored, unless the time period is carefully controlled.

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Mon Jul 02 2007 - 08:36:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US