Re: MINEXTENTS

From: Joseph S. Testa <teci_at_oracle-dba.com>
Date: Mon, 01 May 2000 15:06:46 -0400
Message-Id: <10484.104584@fatcity.com>

--------------26470750E7C2AA9D8318CD7C
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

thats a prime example:

320G table, 16 partitions, 2 gig datafiles., the math: 20G per partition, minextents 10 each of ~2G

joe

"Thapliyal, Deepak" wrote:

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

--------------26470750E7C2AA9D8318CD7C

Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<body bgcolor="#FFFFFF">

thats a prime example:
320G table, 16 partitions, 2 gig datafiles., the math:  20G per
partition, minextents 10 each of ~2G
joe
  
"Thapliyal, Deepak" wrote:
<blockquote TYPE=CITE><style></style>
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 ..
<blockquote style="MARGIN-RIGHT: 0px">
<div class="OutlookMessageHeader" dir="ltr">-----Original
Message-----
 From: Walter K. [<A HREF="mailto:alden14004_at_yahoo.com">mailto:alden14004_at_yahoo.com</A>]
 Sent: Monday, May 01, 2000
11:56 AM
 To: Multiple recipients of
list ORACLE-L
 Subject: MINEXTENTS > 1 ?
  </div>
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</blockquote>
</blockquote>
Received on Mon May 01 2000 - 14:06:46 CDT

Re: MINEXTENTS > 1 ?