idle events in 10gR2
I just noticed this morning that idle events are very easily identifiable by a new column called wait_class in 10gR2
To ignore idle event, I just wrote
select WAIT_CLASS, event
from (
select *
from V$SYSTEM_EVENT
where WAIT_CLASS#!=6
order by TIME_WAITED_MICRO desc)
where rownum<6 ;
WAIT_CLASS EVENT
------------- ----------------------------------------
System I/O log file parallel write
Configuration log file switch (checkpoint incomplete)
Configuration log file switch completion
System I/O db file parallel write
System I/O control file parallel write
December 28th, 2005 at 14:51
There may be however some circumstances where idle events should not be excluded. Recently have seen some interesting things about “SQL*Net message from client” by Doug Burns
http://oracledoug.blogspot.com/2005/12/another-10046-success.html
( here is linked presentation from Gary Goodman also )
Maxim