| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ALTER TABLE MOVE command causes table to grow
Content-Type: text/plain;
charset="iso-8859-1"
you didn't mention the PCT_INCREASE of this segment.
-----Original Message-----
Sent: Thursday, September 05, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Had an annoying surprise last week. A table had grown unexpectedly large and I scheduled a time over the weekend to move it to its own tablespace from my "medium" tablespace.
The table ended up growing 50%. I had anticipated it might grow somewhat given the PCTFREE of 10% but freeing up that space in the blocks should, at most, have caused it to grow by 10% (assuming that 10% was completely full).
Does anyone have ideas as to why it would have grown by so much? Indexes are in a different tablespace and the only other change was from an extent size of 4 meg to one of 25 meg. Both are dictionary managed tablespaces.
Oracle 8.1.7.2
Solaris 2.6
Thanks,
Jay Miller
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: JayMiller_at_TDWaterhouse.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_01C254FD.30CD86B0 Content-Type: text/html; charset="iso-8859-1"Received on Thu Sep 05 2002 - 13:00:03 CDT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RE: ALTER TABLE MOVE command causes table to grow</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>you didn't mention the PCT_INCREASE of this segment.</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Miller, Jay [<A HREF="mailto:JayMiller_at_tdwaterhouse.com">mailto:JayMiller_at_tdwaterhouse.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Thursday, September 05, 2002 12:09 PM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: ALTER TABLE MOVE command causes table to grow</FONT>
</P>
<BR>
<P><FONT SIZE=2>Had an annoying surprise last week. A table had grown unexpectedly large</FONT>
<BR><FONT SIZE=2>and I scheduled a time over the weekend to move it to its own tablespace</FONT>
<BR><FONT SIZE=2>from my "medium" tablespace. </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>The table ended up growing 50%. I had anticipated it might grow somewhat</FONT>
<BR><FONT SIZE=2>given the PCTFREE of 10% but freeing up that space in the blocks should, at</FONT>
<BR><FONT SIZE=2>most, have caused it to grow by 10% (assuming that 10% was completely full).</FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>Does anyone have ideas as to why it would have grown by so much? Indexes</FONT>
<BR><FONT SIZE=2>are in a different tablespace and the only other change was from an extent</FONT>
<BR><FONT SIZE=2>size of 4 meg to one of 25 meg. Both are dictionary managed tablespaces. </FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>Oracle 8.1.7.2</FONT>
<BR><FONT SIZE=2>Solaris 2.6</FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>Thanks,</FONT>
<BR><FONT SIZE=2>Jay Miller</FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Miller, Jay</FONT>
<BR><FONT SIZE=2> INET: JayMiller_at_TDWaterhouse.com</FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from). You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C254FD.30CD86B0-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markham, Richard INET: RMarkham_at_hafeleamericas.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).
 |
 |