free buffer waits等待事件

free buffer waits等待事件

#www.askmaclean.com/archives/direct-path-write.html

free buffer waits等待时间发生在数据库写进程慢时，数据库写进程不能满足维护缓冲区高速缓存的请求。高速缓存中等待写入磁盘的脏数据的数目比数据库写入进程每批次写入的数目大，会话必须等待，因为会话不能获得供写入的可用缓冲区。

解决：

       1、首先排除是否由于高速缓冲区过小。解决此类：启用automatic shared memory management。

       2、较少的dbwr。数据库有较多的数据更改，但是却只有少数的dbwr。增加dbwr的数量。通常可保持在 4个CPU一个DBWR。db_writer_precesses指定DBWR的个数。

Problem

This will happen if there is no free buffer in the buffer cache for the session to read a new block into. All buffer gets have been suspended.

This will frequently occur because DBWR is not writing out buffers fast enough.

This could happen when a file was read-only and is now read-write. All the existing buffers associated with the read-only file need to be invalidated since they are not linked to lock elements (needed when mounted parallel (shared)). So cache buffers are not assigned to data block addresses until the invalidation is finished.

The session moved some dirty buffers to the dirty queue and now this dirty queue is full. The dirty queue needs to be written to the file system first. The session will wait on this event and try again to find a free buffer

This also happens after inspecting free buffer inspected buffers. If no free buffer is found, Oracle waits for one second, and then tries to get the buffer again (depends on the context).

Small buffer cache can cause high free buffer waits when large amount of PIOs and LIOs are taking place.

Solution

Improve DBWR Throughput