Is there a way to reduce the checkpoint duration? There is plenty of advice on checkpoint frequency and I have followed that intently to get our checkpints to no more that every 5 minutes with 0 buffers flushed at peak load during the day, but as the footprint of the database increases so it checkpoint duration. Its currently taking about 30 seconds for each checkpoint to complete and end users are quite rightly complaining about UI performance. Details of database: -
OE 10.2B05 X64
Windows Server 2008R2 Enterprise X64
396GB memory
24 * 2.4 Ghz AMD Opteron Cores
4kb block size
35m in -B
10m in -B2
LRU2 policy remains disabled
1 APW
50 BI Buffs
100000 -spin
99% buffer hits
100% alternate buffer hits
850GB total database size
OE 10.2B05 X64
Windows Server 2008R2 Enterprise X64
396GB memory
24 * 2.4 Ghz AMD Opteron Cores
4kb block size
35m in -B
10m in -B2
LRU2 policy remains disabled
1 APW
50 BI Buffs
100000 -spin
99% buffer hits
100% alternate buffer hits
850GB total database size