| 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"
just to be certain we are on the same page,
you mention uniform sizing which is on
the tablespace level, so I want to make
sure the PCT_INCREASE you provided was pulled
from dba_segments. if so then i'd say a bit
more info would need to have some light shed
on it persay was there much DML put against
this table last week. a PCT_FREE of 10%
wouldn't be such a good idea for a table
with varying length column data.
-----Original Message-----
Sent: Thursday, September 05, 2002 2:43 PM
To: Multiple recipients of list ORACLE-L
pct increase is 0 (uniform sizing)
-----Original Message-----
Sent: Thursday, September 05, 2002 2:00 PM
To: Multiple recipients of list ORACLE-L
you didn't mention the PCT_INCREASE of this segment.
-----Original Message-----
<mailto:JayMiller_at_tdwaterhouse.com> ]
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.comReceived on Thu Sep 05 2002 - 14:18:25 CDT
<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). -- 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_01C25507.DE2ABCB0 Content-Type: text/html; charset="iso-8859-1"
<!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>just to be certain we are on the same page,</FONT>
<BR><FONT SIZE=2>you mention uniform sizing which is on </FONT>
<BR><FONT SIZE=2>the tablespace level, so I want to make</FONT>
<BR><FONT SIZE=2>sure the PCT_INCREASE you provided was pulled</FONT>
<BR><FONT SIZE=2>from dba_segments. if so then i'd say a bit</FONT>
<BR><FONT SIZE=2>more info would need to have some light shed</FONT>
<BR><FONT SIZE=2>on it persay was there much DML put against</FONT>
<BR><FONT SIZE=2>this table last week. a PCT_FREE of 10%</FONT>
<BR><FONT SIZE=2>wouldn't be such a good idea for a table </FONT>
<BR><FONT SIZE=2>with varying length column data.</FONT>
</P>
<BR>
<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 2:43 PM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: RE: ALTER TABLE MOVE command causes table to grow</FONT>
</P>
<BR>
<P><FONT SIZE=2>pct increase is 0 (uniform sizing)</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>Sent: Thursday, September 05, 2002 2:00 PM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
</P>
<BR>
<BR>
<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><<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>
</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>
</P>
<P><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><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>
<P><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_01C25507.DE2ABCB0-- -- 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).
 |
 |