RE: MINEXTENTS

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Mon, 1 May 2000 17:22:52 -0400
Message-Id: <10484.104618@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_01BFB3B3.68805F60
Content-Type: text/plain;

charset="iso-8859-1"

When Oracle allocate extents during table if tablespace has several files it creates extents using round robin in tablespace files - and if these files are on different devices we can achieve distribution of IO.

Alex Hillman

-----Original Message-----
From: Winnie_Liu_at_infonet.com [mailto:Winnie_Liu_at_infonet.com] Sent: Monday, May 01, 2000 5:15 PM
To: Multiple recipients of list ORACLE-L Subject: RE: MINEXTENTS > 1 ?

Umm.. then I have another question, why don't we use ALTER TABLE .. ALLOCATE EXTENT to increase the number of extents of the table to whatever number you wish before you import the table.

Why do we want to use the parameter minextent instead?

Winnie

"Thapliyal, Deepak" <DThapliyal_at_ea.com> on 05/01/2000 12:47:31 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

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-----
Sent: Monday, May 01, 2000 11:56 AM
To: Multiple recipients of list ORACLE-L

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_01BFB3B3.68805F60
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.2448.0">
<TITLE>RE: MINEXTENTS > 1 ?</TITLE>
</HEAD>
<BODY>

When Oracle allocate extents during table if =
tablespace has several files it creates extents using round robin in = tablespace files - and if these files are on different devices we can = achieve distribution of IO.

Alex Hillman


-----Original Message-----
 From: Winnie_Liu_at_infonet.com [<A =
HREF=3D"mailto:Winnie_Liu_at_infonet.com">mailto:Winnie_Liu_at_infonet.com</A>= ]
 Sent: Monday, May 01, 2000 5:15 PM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: MINEXTENTS > 1 ?

 
 

Umm.. then I have another question, why don't we use =
ALTER TABLE ..
 ALLOCATE EXTENT to increase the number of extents of =
the table to whatever
 number you wish before you import the table.


Why do we want to use the parameter minextent =
instead?


Winnie

 
 
 
 

"Thapliyal, Deepak" =
<DThapliyal_at_ea.com> on 05/01/2000 12:47:31 PM


Please respond to ORACLE-L_at_fatcity.com


To:   Multiple recipients of list ORACLE-L =
<ORACLE-L_at_fatcity.com>
 cc:    (bcc: Winnie =
Liu/HQ/ISC)

 
 
 
 

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-----
 Sent: Monday, May 01, 2000 11:56 AM
 To: Multiple recipients of list ORACLE-L

 

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.
Received on Mon May 01 2000 - 16:22:52 CDT