Free buffer waits occur when a session needs to read a data block from a database file on disk into the buffer cache. If there are no unmodified (or clean) blocks in the buffer cache, then the session has to wait for the database writer process to write modified (or dirty) blocks to disk in order for free buffers to be made available.
Normally, the database writer is constantly writing dirty buffers to disk, so this event rarely occurs. When it does occur, it is usually due to one of the following reasons:
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center