Message-Id: <10484.104584@fatcity.com> From: "Joseph S. Testa" Date: Mon, 01 May 2000 15:06:46 -0400 Subject: Re: MINEXTENTS > 1 ? --------------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@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 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@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