/O,due to this you will see Db sequential read and buffer busy wait.On
one of our busiest days it came to an extent where the cpu idle time came to
0%.
The only option was to enable Cached Quick I/o which is now causing the
reverse, it causing write complete waits and this file open event,which
days it came to an extent where the cpu idle time came to
0%.
The only option was to enable Cached Quick I/o which is now causing the
reverse, it causing write complete waits and this file open event,which was
worrying me.
Please let me know if you faced any issue.
From: Steve Adams [EMAIL
Hi Arun,
Foreground processes open the datafiles only when they need to read from them
(or write to them in the case of a sort). The 'file open' wait event represents
the opening of and typically the first I/O operation against that datafile,
however, sometimes a few extraneous I/O operations
Can Somebody please explain to me what this event is , I am not able to find
good documentation on this issue.
EVENT TOTAL_WAIT TOTAL_TIME TIME_WAITE AVERAGE_WA
-- -- --
file identify38343 0 3135 .08176199
file open