Re: estimating space saved as a result of reorganizing table

  • From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
  • To: hrishys@xxxxxxxxxxx
  • Date: Mon, 20 Aug 2007 11:34:53 -0500


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
  - Refresh your test or development database from production (using a clone
procedure, not exp/imp), then a test reorganization, measuring the resulting
  - 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: