Re: Tables Size

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 17 Nov 2011 13:28:52 +0000
Message-ID: <CABe10sYZ5cbqBHbiDpnM7u=t5XcS3m3W-9rQDsjeKK6bYexbZw_at_mail.gmail.com>



Sanjay
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"<http://docs.oracle.com/cd/B19306_01/server.102/b14231/schema.htm#CBBDDBJH>,
> later in this section. For details on how to view results, see "Viewing
> Segment Advisor Results"<http://docs.oracle.com/cd/B19306_01/server.102/b14231/schema.htm#CBBJHIGH>
> .
> (Optional) Obtain updated results on individual segments by rerunning the
> Segment Advisor manually.
> See "Running the Segment Advisor Manually"<http://docs.oracle.com/cd/B19306_01/server.102/b14231/schema.htm#CBBBJFGC>,
> later in this section.

On Thu, Nov 17, 2011 at 12:38 PM, Sanjay Mishra <smishra_97_at_yahoo.com>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
http://www.orawin.info


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 17 2011 - 07:28:52 CST

Original text of this message