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

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