RE: Tablespace reorg tools

From: Bruce Page <bpage_at_kimball.com>
Date: Thu, 27 Apr 2000 07:39:41 -0500
Message-Id: <10480.104282@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_01BFB045.B58FDEC0
Content-Type: text/plain;

charset="iso-8859-1"

Indexes is one example. If it has been a while since you have rebuilt your indexes (which is something I need to do soon) and you have had a lot of updates and deletes to the indexes, you will have a lot of dead holes in your indexes. COMPRESS=Y will make the initial extent of the index the total of all the allocated extents. If you are doing the export to rebuild your database to free up space, this defeats your purpose.

-----Original Message-----
From: George.Brennan_at_warnermusic.com
[mailto:George.Brennan_at_warnermusic.com]
Sent: Thursday, April 27, 2000 7:44 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Tablespace reorg tools

> Deepak,
>
> I believe COMPRESS=Y will resize the initial extent, but the next
> extent will remain the same size. If initial was 16K and next was
> 16K, and you have inserted a few thousand records, and export
> with COMPRESS=Y, oracle will recalculate the initial (so all records
> fit in the initial extent) *but* the next extent will still be 16K.
> This is usually a *bad* thing.
>

Ok, I'll bite, why is it usually a *bad* thing?

George.

-- 
Author: 
  INET: George.Brennan_at_warnermusic.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_01BFB045.B58FDEC0
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: Tablespace reorg tools</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>Indexes is one example.&nbsp; If it has been a while =
since you have rebuilt your indexes (which is something I need to do =
soon) and you have had a lot of updates and deletes to the indexes, you =
will have a lot of dead holes in your indexes.&nbsp; COMPRESS=3DY will =
make the initial extent of the index the total of all the allocated =
extents.&nbsp; If you are doing the export to rebuild your database to =
free up space, this defeats your purpose.</FONT></P>
<BR>
<BR>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: George.Brennan_at_warnermusic.com</FONT>
<BR><FONT SIZE=3D2>[<A =
HREF=3D"mailto:George.Brennan_at_warnermusic.com">mailto:George.Brennan_at_war=
nermusic.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, April 27, 2000 7:44 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: RE: Tablespace reorg tools</FONT>
</P>
<BR>
<BR>

<P><FONT SIZE=3D2>&gt; Deepak,</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; I believe COMPRESS=3DY will resize the initial =
extent, but the next </FONT>
<BR><FONT SIZE=3D2>&gt; extent will remain the same size.&nbsp; If =
initial was 16K and next was </FONT>
<BR><FONT SIZE=3D2>&gt; 16K, and you have inserted a few thousand =
records, and export</FONT>
<BR><FONT SIZE=3D2>&gt; with COMPRESS=3DY, oracle will recalculate the =
initial (so all records </FONT>
<BR><FONT SIZE=3D2>&gt; fit in the initial extent) *but* the next =
extent will still be 16K.&nbsp; </FONT>
<BR><FONT SIZE=3D2>&gt; This is usually a *bad* thing.</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
</P>

<P><FONT SIZE=3D2>Ok, I'll bite, why is it usually a *bad* =
thing?</FONT>
</P>

<P><FONT SIZE=3D2>George.</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: </FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: George.Brennan_at_warnermusic.com</FONT>
</P>

<P><FONT SIZE=3D2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) =
538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from).&nbsp; You may</FONT>
<BR><FONT SIZE=3D2>also send the HELP command for other information =

Received on Thu Apr 27 2000 - 07:39:41 CDT