Re: Tablespace reorganisation

--- Yadavalli Aditya <aditya.yadavalli@xxxxxxxxx> wrote:
> How can we know that a tablespace needs to be reorganised....?

When you have ton of free space and none of your active segments will ever be
able to occupy it.

This happens when you inherit a database that was build using dictionary
managed tablespaces with PCTINCREASE > 0 and a tablespace now looks like a
swiss cheese with bunch of holes of different sizes (check dba_free_space).

You can still fix it by carefully altering the next extent of your active
segments to eventually fill the free space.  You have to have the patience, a
way to monitor segment growth and fairly active segments to do this -- if you
don't then reorg. or leave it alone - space is cheap.

Don't confuse this with segment reorganization - they are different.

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

Other related posts: