RE: Block Size and # of Extents

Lisa,
Farmula as under :(courtsy Gogala Mladen)

(db_block_size / 16) - 7

8192/16 - 7 = 505 blocks

Regards
Rafiq

From: "Koivu, Lisa" <lkoivu_at_qode.com>
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: RE: Block Size and # of Extents Date: Mon, 09 Oct 2000 05:11:33 -0800

Rajesh, were you letting the maxextents value default when creating a tablespace? It looks like it. The default maxextents number is set based upon a formula that I don't readily see in the documentation at first glance. If you specificially set maxextents when creating a tablespace, you will not see this behavior. I'm sure someone else on the list will find the formula and send it.

(I learned this from someone on the list last year.)

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319

V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849

"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."

-----Original Message-----
Sent: Monday, October 09, 2000 8:31 AM
To: Multiple recipients of list ORACLE-L

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).

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at