Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: INITIAL and NEXT extent sizing question
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_01C027AF.35306800
Content-Type: text/plain
I think U can set NEXT also same as INITIAL.
Venkat
Ph:7846101- Extn: 5648
> ----------
> From: Fred Smith[SMTP:fred_fred_1_at_hotmail.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Monday, September 25, 2000 10:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: INITIAL and NEXT extent sizing question
>
> I have a table with rows currently populating. I wish to resize the table
>
> for better performance. What is the best way I should figure out how to
> size my INITIAL and NEXT extent sizes for this table. Is it just:
> 1) Analyze the table
> 2) SELECT BLOCKS * (block_size) from dba_tables for the table in question
> =
> what the initial size should be set to.
> 3) What determines what I should set the NEXT extent size to then?
>
> Thank you,
> -Fred S.
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Fred Smith
> INET: fred_fred_1_at_hotmail.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_01C027AF.35306800
Content-Type: text/html
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=3Dus-ascii">
<TITLE>RE: INITIAL and NEXT extent sizing question</TITLE> </HEAD> <BODY>
<P><FONT COLOR=3D"#800080" SIZE=3D2 FACE=3D"Arial">I think U can =
set NEXT also same as INITIAL. </FONT>
</P>
<BR>
<P><FONT COLOR=3D"#008000" SIZE=3D4 FACE=3D"MS Sans =
Serif">Venkat</FONT>
<BR><FONT COLOR=3D"#800080" SIZE=3D2 FACE=3D"MS Sans Serif">Ph:7846101- =
Extn: 5648</FONT>
</P> <UL> <P><FONT SIZE=3D1 FACE=3D"MS Sans Serif">----------</FONT> <BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">From:</FONT></B> = <FONT SIZE=3D1 FACE=3D"MS Sans Serif">Fred =Smith[SMTP:fred_fred_1_at_hotmail.com]</FONT> <BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">Reply To:</FONT></B> = <FONT SIZE=3D1 FACE=3D"MS Sans = Serif">ORACLE-L_at_fatcity.com</FONT>
<P><FONT SIZE=3D2 FACE=3D"Arial">I have a table with rows currently =
populating. I wish to resize the table </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">for better performance. What is =
the best way I should figure out how to </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">size my INITIAL and NEXT extent sizes =
for this table. Is it just:</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">1) Analyze the table</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">2) SELECT BLOCKS * (block_size) from =
dba_tables for the table in question =3D </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">what the initial size should be set =
to.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">3) What determines what I should set =
the NEXT extent size to then?</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Thank you,</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial"> -Fred S.</FONT> <BR><FONT SIZE=3D2 = FACE=3D"Arial">_________________________________________________________= ________________</FONT>
<P><FONT SIZE=3D2 FACE=3D"Arial">Share information about yourself, =
create your own public profile at </FONT>
<BR><U><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial"><A =
HREF=3D"http://profiles.msn.com" =
TARGET=3D"_blank">http://profiles.msn.com</A></FONT></U><FONT SIZE=3D2 =
FACE=3D"Arial">.</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Please see the official ORACLE-L =
FAQ:</FONT><U> <FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial"><A =
HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT></U>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Fred Smith</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial"> INET: =fred_fred_1_at_hotmail.com</FONT>
<P><FONT SIZE=3D2 FACE=3D"Arial">Fat City Network =
Services -- (858) 538-5051 FAX: (858) =
538-5051</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">San Diego, =
California -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">---------------------------------------------------------=-----------</FONT>
![]() |
![]() |