db_block_max_dirty_target - PT
I got this question on an STS practice test:
"What two things could result from an excessively high setting for DB_BLOCK_MAX_DIRTY_TARGET."
The answer was "Dirty buffers are written too frequently" and "DBWn will use more memory".
Now I'll go with the former but is the latter really true? After several direct quotes from Oracle documentation (funnily enough reading is a little trick I picked up in junior school!), the STS mentor suggested that DBWn may need to borrow additional memory from the SGA or even system memory in order to cache all the blocks before writing.
I can't see anywhere in technet this can be confirmed.
Click Here to Expand Forum to Full Width