Re: Tables Size
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: smishra_97@xxxxxxxxx
- Date: Thu, 17 Nov 2011 13:28:52 +0000
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@xxxxxxxxx>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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
