Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> my max db_file_multiblock_read_count is 128.. why?

my max db_file_multiblock_read_count is 128.. why?

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 26 Aug 2002 18:08:07 GMT
Message-ID: <3d6a6e60.1484346567@news.globix.com>


[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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US