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 -> Re: DB_FILE_MULTIBLOCK_READ_COUNT multiple of 5 ?

Re: DB_FILE_MULTIBLOCK_READ_COUNT multiple of 5 ?

From: <pjackson_at_hilliard.com>
Date: Mon, 29 Mar 1999 18:56:19 GMT
Message-ID: <7doicf$lf4$1@nnrp1.dejanews.com>


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

Original text of this message

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