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: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Mon, 02 Jul 2007 06:30:15 -0700
Message-ID: <1183383015.125796.244770@c77g2000hse.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

Try doing a google search on oracle idle events if you don't want to do your research on oracle documentation ( http://tahiti.oracle.com ) or via metalink.

Be careful of some of the hits that you get from google searches if you know what I mean ( no silver bullets ). Received on Mon Jul 02 2007 - 08:30:15 CDT

Original text of this message

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