Tru64 4.0F and ADVFS
Oracle extent size and operating system i/o buffer:
===================================================
The Oracle Press 8i DBA Handbook text states that extent sizes should
be set to take advantage of Oracle multiblock reads. If the table
extent size is not a multiple of the I/O buffer, then the number of
reads required may increase.
What parameters on the Digital Unix platform control this operating
system i/o buffer?
Does ADVFS buffer config have a play in this performance tuning issue?
What needs to be set in advfs or kernel parameters?
Possible Kernel Parameters:
===========================
io:
max-iosize-read 65536 (can go up to 2147483647)
max-iosize-write 65536 (can go up to 2147483647)
vfs:
bufcache 3 (can go up to 50)
bufpages 1958 (can go up to 9223372036854775807)
pipe-maxbuf-size 65536 (can go up to 262144)
pipe-databuf-size 8192 (can go up to 16384)
vm:
vm-ubcbuffers 256 (can go up to 2147483647)
===============================================================
Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D
Received on Wed Dec 06 2000 - 17:00:17 NZDT