PPT Slide
Selected parameters with significant effect
LRU_MAX_DIRTY and LRU_MIN_DIRTY
Depends on what you are doing and on other parameters.
More important than ever with fuzzy checkpointing! Now the ONLY flushing!
OLTP - set to 2/0, 5/1, or other low values.
DSS/DW - set to 60/50 or other high values.
Longer CKPTINTVL? Set these lower. Shorter CKPTINTVL? Set higher.