| 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
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
"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_at_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_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). ------_=_NextPart_001_01C031EA.6E87377C Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: Block Size and # of Extents</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>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. </FONT></P> <P><FONT SIZE=3D2>(I learned this from someone on the list last = year.)</FONT> </P> <P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT> <BR><FONT SIZE=3D2>Oracle Database Administrator</FONT> <BR><FONT SIZE=3D2>Qode.com</FONT> <BR><FONT SIZE=3D2>4850 North State Road 7</FONT> <BR><FONT SIZE=3D2>Suite G104</FONT> <BR><FONT SIZE=3D2>Fort Lauderdale, FL 33319</FONT> </P> <P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT> <BR><FONT SIZE=3D2>F: 954.484.2933 </FONT> <BR><FONT SIZE=3D2>C: 954.658.5849</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A></FONT> </P> <P><FONT SIZE=3D2>"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."</FONT></P> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Rajesh Dayal [<A = HREF=3D"mailto:Rajesh_at_ohitelecom.com">mailto:Rajesh_at_ohitelecom.com</A>]<= /FONT> <BR><FONT SIZE=3D2>Sent: Monday, October 09, 2000 8:31 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Block Size and # of Extents</FONT> </P> <BR> <P><FONT SIZE=3D2>Hi everybody,</FONT> </P> <P> <FONT SIZE=3D2>Can = someone explain to me why the Maximum</FONT> <BR><FONT SIZE=3D2>no of extents increase with the Block Size of = </FONT> <BR><FONT SIZE=3D2>Database ? For Example,</FONT> </P> <P><FONT SIZE=3D2>Block size = Max # of Extents</FONT> <BR><FONT SIZE=3D2>2k = = 121</FONT> <BR><FONT SIZE=3D2>4k = = 255</FONT> <BR><FONT SIZE=3D2>8k = = 504</FONT> <BR><FONT SIZE=3D2>16k = = 1032</FONT> <BR><FONT SIZE=3D2>32k = = 2070</FONT> </P> <P><FONT SIZE=3D2>Manuals say</FONT> </P> <P><FONT SIZE=3D2>>> </FONT> <BR><FONT SIZE=3D2>The number of extents per Oracle block depends = on</FONT> <BR><FONT SIZE=3D2>operating system block size and platform. = Although</FONT> <BR><FONT SIZE=3D2>an extent is a data structure inside Oracle, the = </FONT> <BR><FONT SIZE=3D2>size of this data structure depends on operating = </FONT> <BR><FONT SIZE=3D2>system. Accordingly, this affects the number of = </FONT> <BR><FONT SIZE=3D2>extents which can be stored in a single = operating</FONT> <BR><FONT SIZE=3D2>system block.</FONT> <BR><FONT SIZE=3D2><<</FONT> </P> <P> <FONT SIZE=3D2>The = explanation has stumped me :-|</FONT> </P> <P><FONT SIZE=3D2>Thanks for your time,</FONT> <BR><FONT SIZE=3D2>Rajesh</FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Rajesh Dayal</FONT> <BR><FONT SIZE=3D2> INET: Rajesh_at_ohitelecom.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =Received on Mon Oct 09 2000 - 07:14:09 CDT
 |
 |