Hi everyone,

When I ran the following query on a database that has been up for one month I was shocked:

select sum(time_waited)/360000 "hours waited since startup"
from v$system_event
where event not like 'SQL*Net%' and event not like '%timer' and event not like '%ipc%';

The query returned a total wait time around 70 hours! Almost 65 hours come from the 'db file sequential read' event.

Do these figures look normal or does this database have a serious I/O problem? (Or am I missing some essential point?)

Thanks!
Dorian