Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> my max db_file_multiblock_read_count is 128.. why?
[lroot/dragon@: ]echo 'vol_maxio /D' | adb -k
physmem 1390ee
vol_maxio:
vol_maxio: 512
(256K)
[lroot/dragon@: ]echo 'maxphys /D' | adb -k
physmem 1390ee
maxphys:
maxphys: 131072
(128K)
Oracle Block size=4K
So I'd expect my max multi_block_read to be 64 (or even 32, not 100% sure if maxphys has anything to do w/ vxfs)
however
multiblock_read_test.sql (from Steve Adams/ixora.com.au)
shows that it's 128
Are oracle reported scattered reads not actual physical reads?
Any extra insight is appreciated.
.......
We use Oracle 8.1.7.3 on Solaris 2.7 boxes
remove NSPAM to email
Received on Mon Aug 26 2002 - 13:08:07 CDT