table reorg - need experts advise
Hi Guys,
10.2.0.4
Currently, our criteria re-org is for table with > 10% chain counts to get rid of migrated rows which require addition i/o for index read.
Is it good to have another criteria to re-org table with holes in it? Understand that if we defrag it, the full scan elapsed time will improve..
however for subsequent inserts, will it have to spend additional resource to extend additional space? is it better not to re-org as eventually oracle will make use of the empty space. we are using lmt tablespace.
Can advise how many ppl here are doing re-org of table due to it? hope u guys can share experience on this.
If need to do for fragmented space, how much empty space is considered alot for a table to be choosen as re-org?
thanks