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

Other related posts: