Oracle Indexing

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:

Oracle Indexing

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:

RE: Oracle Indexing

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