Re: Tablespace reorganisation
- From: MVE <mvetmp-ora@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 31 May 2006 12:43:50 -0700 (PDT)
--- 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
