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

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 5 Jan 2007 04:00:25 -0800
Message-ID: <1167998425.044359.208780@v33g2000cwv.googlegroups.com>

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. Received on Fri Jan 05 2007 - 06:00:25 CST