| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> DB_MULTIBLOCK_READ_COUNT and DB_BLOCK_SIZE
Hi! Oracle gurus
I am running 7.3.3.0.2 on Solaris 2.51. I need to know how much of a
performance gain can one expect by increasing the DB_BLOCK_SIZE to 4 or
8K and the DB_MULTIBLOCK_READ_COUNT to 16 or 32 for a highly read
intensive and low-write intensive setup. I understand that the results
vary with every situation - but can I expect atleast a low to moderate
performance gain ? Has anyone seen a case where doing so actually
degraded performance ?
Or is my question too generic ?
Any input will be greatly appreciated
Venkat
vreddy_at_wsg1.usa.com
Received on Sat Jul 19 1997 - 00:00:00 CDT
![]() |
![]() |