Tuning Disk I/O
Sequential Vs Random I/O
onstat -p, Read Cache >= 95%, Write Cache >=85%
onstat -g ioq, onstat -g iof, onstat -g ppf
Read Ahead Values
OLTP - RA_PAGES = 32, RA_THRESHOLD = 28
DSS - Increase Until Benefit Ceases, Start With 128, 124
Previous slide
Next slide
Back to first slide
View graphic version