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

1 thought on “idle events in 10gR2

Comments are closed.