Re: Tables Size

From: Niall Litchfield <>
Date: Thu, 17 Nov 2011 13:28:52 +0000
Message-ID: <>

That's what the segment advisor is designed for! I'm going to quote directly from the relevant manual because I agree 100% with it.

If you receive a space management alert, or if you decide that you want to
> reclaim space, you should start with the Segment Advisor.
> To use the Segment Advisor:
> Check the results of the Automatic Segment Advisor.
> To understand the Automatic Segment Advisor, see "Automatic Segment
> Advisor"<>,
> later in this section. For details on how to view results, see "Viewing
> Segment Advisor Results"<>
> .
> (Optional) Obtain updated results on individual segments by rerunning the
> Segment Advisor manually.
> See "Running the Segment Advisor Manually"<>,
> later in this section.

On Thu, Nov 17, 2011 at 12:38 PM, Sanjay Mishra <>wrote:

> I am trying to check as the best way to find out the actual space used by
> table removing any fragmentation in it. I had few partitioned table in 3
> digit like one of the table was 150G. I used redefinition package and it
> becomes 70G.

Niall Litchfield
Oracle DBA

Received on Thu Nov 17 2011 - 07:28:52 CST

Original text of this message