If this parameter is set too high, the DBWn process might not write dirty buffers often
enough, which can cause sessions to wait for free buffers.
A excessive high value for the DB_BLOCK_MAX_DIRTY_TARGET parameter
causes extra memory to be used by the DBWn process. The extra memory is allocated
in the master process. Also, delays in read and write operations may be seen if this
value exceeds the operating system capacity to process all requests, because these
requests are queued waiting for the disk to become available.
When setting this parameter, analysis of database statistics related to DBWn, such as
the wait event WRITE COMPLETE WAITS in the V$SYSTEM_EVENT, is needed to
determine whether you can benefit from a decreased value for
DB_BLOCK_MAX_DIRTY_TARGET.