Re: Tables Size

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 17 Nov 2011 15:29:42 +0000
Message-ID: <CABe10sai9g1AKjw6Z2AEit3-SQEGuL+D+ER4GtcG_y6Qeknf0Q_at_mail.gmail.com>

In the absence of space pressure in the tablespace (i.e the tablespace space threshold isn't breached) then I believe that to be correct since the advisor won't be able to determine the growth rate for that object. That's pretty much the reason that you'd check the automatic results first and then if you are still concerned about specific objects then look at those specifically.
On Thu, Nov 17, 2011 at 2:47 PM, Sanjay Mishra <smishra_97_at_yahoo.com> wrote:

> 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"<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
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 17 2011 - 09:29:42 CST