Re: wait event "null event" in 9.2.0.1 in windows XP

Charles Hooper wrote:
> peter wrote:
> > getting
> > "null event" in 9.2.0.1 in windows XP in v$session_wait wait event,
> > Please tell me what do to.
> > If it is a bug then please tell me patch no. to apply so that this
> > problem can be solved.
>
> http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14211/instance_tune.htm
> (Note the above link contains some 10g specific information, but more
> will apply to 9.2)
>
> Null event, like the various SQL*Net wait events are idle events. You
> can safely ignore idle events while viewing the various performance
> views. Some idle events, such as "SQL*Net message from client" can
> contain useful information at the session level with a properly defined
> start and end time, or when present in a 10046 trace file for a
> session.
>
> Charles Hooper
> PC Support Specialist
> K&M Machine-Fabricating, Inc.

Null events are not necessarily idle events. They are just events which have not been
classified. Most likely they are idle events .. but sometimes are events which
are non-idle and should have been classified.

Although the following bug might be more relevant to UNIX .. still .. See bug 3070842 9.2.0.3 HAS MANY "NULL EVENT" WAIT EVENTS.

Usually best to patch to latest version ... 9.2.0.8. That might help.

Anurag Received on Fri Jan 05 2007 - 10:22:44 CST