Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DB_FILE_MULTIBLOCK_READ_COUNT multiple of 5 ?
From my understanding the DB_FILE_MULTIBLOCK_READ_COUNT parameter is most
important for determining proper sizes of extents. There are some good
whitepapers titled Oracle7 Server Space Management and Avoiding a Database
Reorganization which cover these issues. The relevant point is that to
optimize full table scans it is useful to size extents according to the
formula (2^k)bm; where k=0,1,2,...; b=DB_BLOCK_SIZE; and
m=DB_FILE_MULTIBLOCK_READ_COUNT. By using this method you can ensure that you
have efficient data access even if you do not have all your data stored in
one extent.
Paul
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 29 1999 - 12:56:19 CST