Message-Id: <10644.118777@fatcity.com> From: "Koivu, Lisa" Date: Mon, 9 Oct 2000 08:14:09 -0400 Subject: RE: Block Size and # of Extents This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C031EA.6E87377C Content-Type: text/plain; charset="iso-8859-1" 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 http://www.qode.com "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----- From: Rajesh Dayal [mailto:Rajesh@ohitelecom.com] Sent: Monday, October 09, 2000 8:31 AM To: Multiple recipients of list ORACLE-L Subject: Block Size and # of Extents 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@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@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). ------_=_NextPart_001_01C031EA.6E87377C Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Block Size and # of Extents

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
http://www.qode.com

"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-----
From: Rajesh Dayal [mailto:Rajesh@ohitelecom.com]<= /FONT>
Sent: Monday, October 09, 2000 8:31 AM
To: Multiple recipients of list ORACLE-L
Subject: Block Size and # of Extents


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@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@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 =