RE: segment issue

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Mon, 31 Oct 2011 14:17:10 -0400
Message-ID: <00e901cc97f9$4f42cad0$edc86070$_at_rsiz.com>

I'll take a stab at what I *think* you are describing. You moved a table without changing the pctfree and the extent sizes haven't changed either, but the destination is bigger than the source.

Consider that percent free and percent used control whether a block is a candidate for the insertion of new rows. Now let's suppose that most of your rows grow after insert because some column values are born null or with small defaults that become longer.
So your blocks are routinely much fuller than the original insertion size.

The other possibility is that the extent sizes have changed and the last extent is now more empty. Or you could have changed initrans.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Fitzjarrell
Sent: Monday, October 31, 2011 12:46 PM
To: yang liu
Cc: oracle-l_at_freelists.org
Subject: Re: segment issue

Please post the entire text of the alter table move command as well as the tablepace definitions and Oracle release in use (all 4 to 5 numbers).  Your 'problem' still isn't clearly defined.

David Fitzjarrell

From: yang liu <ylouis83_at_gmail.com>
To: David Fitzjarrell <oratune_at_yahoo.com> Sent: Monday, October 31, 2011 9:30 AM
Subject: Re: segment issue

That why after I alter xxx table move  whitout changing the pctfree   the segment size of the table become larger ?  exactly from 55GB to  65GB 

2011/11/1 David Fitzjarrell <oratune_at_yahoo.com>

A suggestion for what, exactly?  Your problem is not clearly stated.
>
>
>David Fitzjarrell
>
>
>
>From: yang liu <ylouis83_at_gmail.com>
>To: oracle-l_at_freelists.org
>Sent: Monday, October 31, 2011 9:22 AM
>Subject: segment issue
>
>
>dba_segments,
>and I comfirm that the pctfree is not changed  .the table is from 55GB
>to 65GB Can anyone give me a suggestion?  thanks
>
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 31 2011 - 13:17:10 CDT