RE: segment issue
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <oratune@xxxxxxxxx>, "'yang liu'" <ylouis83@xxxxxxxxx>
- Date: Mon, 31 Oct 2011 14:17:10 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of David Fitzjarrell
Sent: Monday, October 31, 2011 12:46 PM
To: yang liu
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx>
To: David Fitzjarrell <oratune@xxxxxxxxx>
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@xxxxxxxxx>
A suggestion for what, exactly? Your problem is not clearly stated.
>
>
>David Fitzjarrell
>
>
>
>From: yang liu <ylouis83@xxxxxxxxx>
>To: oracle-l@xxxxxxxxxxxxx
>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
>
>
>--
>//www.freelists.org/webpage/oracle-l
>
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
