-
Enormous wait times!
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|