Max IO size

I've got a sun (solaris 2.8) box with with datafiles under vxfs. After setting

• maxphys to 512k
• vxiomax to 512k
• db block size to 8k
• multiblock read count to 64

I had presumed that I could get a ceiling of half a meg per read on (say) a full table scan, but a level 8 10046 trace yields a ceiling of 256k (ie p3 in the waits is 32 not 64)

I'll be repeating the test under a raw partition tomorrow but comments anyone ? As a related question, anyone know what Oracle's SSTIOMAX is under the various versions (say from 7.3)

Cheers

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."