Re: Tables Size
Date: Thu, 17 Nov 2011 06:47:15 -0800 (PST)
Message-ID: <1321541235.6615.YahooMailNeo_at_web161204.mail.bf1.yahoo.com>
Thanks Niall. I just want to check one more thing here. As per the documentation, "The Automatic Segment Advisor does not analyze every database object. Instead, it examines database statistics, samples segment data, and then selects the following objects to analyze:"
If the Statistics for some table is locked or not collected in the given maintenance Window, Does that mean that Daily or Weekend Segment Advisor will skip those objects and need manual intervention by running segment advisor
Rgds
Sanjay
From: Niall Litchfield <niall.litchfield_at_gmail.com> To: smishra_97_at_yahoo.com
Cc: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Thursday, November 17, 2011 8:28 AM Subject: Re: Tables Size
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", 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 <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-lReceived on Thu Nov 17 2011 - 08:47:15 CST