doc

    Name:   buffwait.sql

    Author: Mark Gurry


The following script lists the number of waits for free buffer to be
made available for new data being brought into the buffer cache. The 
output is often a sign of an untuned DBWR of a buffer cache that is
too small. 

#

select name, value
  from v$sysstat
 where name = ‘free buffer waits’;