Re: session wait stats

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