| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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=20 Database ? For Example,
Block size Max # of Extents 2k 121 4k 255 8k 504 16k 1032 32k 2070
Manuals say
>>=20
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=20
size of this data structure depends on operating=20
system. Accordingly, this affects the number of=20
extents which can be stored in a single operating
system block.
<<
The explanation has stumped me :-|
Thanks for your time,
Rajesh
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--=20
Author: Rajesh Dayal
INET: Rajesh_at_ohitelecom.com=20
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 Mon Oct 09 2000 - 07:05:40 CDT
 |
 |