RE: Block Size and # of Extents

The general formula for the maximum number of extents is:  Max number of extents = BS/16-7 (BS being block size, not the output of certain bovine animals)

-----Original Message-----
From: Tim Sawmiller [mailto:sawmillert_at_state.mi.us] Sent: Monday, October 09, 2000 9:11 AM
To: Multiple recipients of list ORACLE-L Subject: Re: Block Size and # of Extents

The header keeps a sort of index of all the extents, reserving a few bytes for each extent. So, the bigger the block, the more extents can be in the index. Now that you can have unlimited extents in Oracle 8, I suspect that the index can now span across blocks, allowing for this.

>>> Rajesh_at_ohitelecom.com 10/09/00 08:31AM >>> Hi everybody,

        Can someone explain to me why the Maximum no of extents increase with the Block Size of Database ? For Example,

Block size 		Max # of Extents
2k			121
4k			255
8k			504
16k			1032
32k			2070

Manuals say

>>

The number of extents per Oracle block depends on operating system block size and platform. Although an extent is a data structure inside Oracle, the size of this data structure depends on operating system. Accordingly, this affects the number of extents which can be stored in a single operating system block.
<<

        The explanation has stumped me :-|

Thanks for your time,
Rajesh

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Rajesh Dayal
  INET: Rajesh_at_ohitelecom.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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Sawmiller
  INET: sawmillert_at_state.mi.us

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