Oracle-L: RE: Oracle Indexing

From: Jack C. Applewhite <japplewhite_at_inetprofit.com>
Date: Fri, 08 Mar 2002 05:18:22 -0800
Message-ID: <F001.004232EB.20020308051822@fatcity.com>

Sinardy,

5 DB blocks is the default for INITIAL and NEXT extents, if you don't specify them, not necessarily the recommended size.

The extent size of any segment depends more on the size of the segment, but should always be an integer multiple of db_file_multiblock_read_count. The best recommendation is to have one or a few standard extent sizes in locally-managed tablespaces.

Jack

Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
japplewhite_at_inetprofit.com
(512)327-9068

-----Original Message-----
Sent: Friday, March 08, 2002 1:48 AM
To: Multiple recipients of list ORACLE-L

Hi all,

Oracle said:
The best extent size of an index to minimize fragmetation is 5 times of db block size.

My question is why 5 times is the recommended size, why not 4 times or 6 times or perhaps 0.5 of your db block size.

Thanks

Sinardy

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack C. Applewhite
  INET: japplewhite_at_inetprofit.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may


also send the HELP command for other information (like subscribing).

Received on Fri Mar 08 2002 - 07:18:22 CST