Re: Tablespace reorganisation

• Yadavalli Aditya <aditya.yadavalli_at_gmail.com> 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