Re: estimating space saved as a result of reorganizing table

Hrishy,

There was another discussion on this topic recently on this list, you may want to review the recent messages.

Since nobody has responded to your request yet, I'll offer a couple of suggestions.

• Refresh your test or development database from production (using a clone procedure, not exp/imp), then a test reorganization, measuring the resulting size.
• Do a Google search on "oracle table space estimate". Eventually you'll find some papers that describe methods for performing estimates. Ensure you have reasonably fresh statistics on this table, then take AVG_ROW_LEN and calculate how many rows will fit into a block, given the block overhead (this is the tough part), and your PCT_FREE setting. This is not exact, but can give you a fairly close estimate.

Dennis Williams

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