RE: MINEXTENTS

From: Thapliyal, Deepak <DThapliyal_at_ea.com>
Date: Mon, 1 May 2000 11:40:18 -0700
Message-Id: <10484.104577@fatcity.com>

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_01BFB39C.B22E4E74
Content-Type: text/plain;

charset="iso-8859-1"

lets assume that you have a dw table which u expect to grow in gigs .. you would probabaly use more then 1 ext to start with for suh tables so that it has a big size to begin with ..

-----Original Message-----
From: Walter K. [mailto:alden14004_at_yahoo.com] Sent: Monday, May 01, 2000 11:56 AM
To: Multiple recipients of list ORACLE-L Subject: MINEXTENTS > 1 ?

When would you want to set MINEXTENTS to something other than '1' for a table? The only case I can think of is if I am trying to manually stripe a table/tablespace across multiple disks.

Thanks.
-w

------_=_NextPart_001_01BFB39C.B22E4E74
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.00.2314.1000" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=453073518-01052000>lets
assume that you have a dw table which u expect to grow in gigs .. you would probabaly use more then 1 ext to start with for suh tables so that it has a big size to begin with ..</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">

<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Walter K. [mailto:alden14004_at_yahoo.com]<BR><B>Sent:</B> Monday, May 01, 2000 11:56 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> MINEXTENTS > 1 ?<BR><BR></DIV></FONT> <DIV><FONT face=Arial size=2>When would you want to set MINEXTENTS to something other than '1' for a table? The only case I can think of is if I am trying to manually stripe a table/tablespace across multiple disks.</FONT></DIV>

  <DIV>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>Thanks.</FONT></DIV>
  <DIV><FONT face=Arial size=2>-w</FONT></DIV></BLOCKQUOTE></BODY></HTML>

Received on Mon May 01 2000 - 13:40:18 CDT

RE: MINEXTENTS > 1 ?