Re: Tables Size
- From: G <andrew.kerber@xxxxxxxxx>
- To: "smishra_97@xxxxxxxxx" <smishra_97@xxxxxxxxx>
- Date: Thu, 17 Nov 2011 07:33:18 -0600
If you have stats gathered, take avg_row_len and multiply by num_rows (from Dba
tables view). Then subtract that from the numbers you get from Dba segments.
Sent from my iPhone
On Nov 17, 2011, at 6:38 AM, 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. This is in 11g where database is upgraded from 10g to 11g.
> Tablespaces are with ASSM. So question
> 1. What is the best way to get the actual size of the table data. Please
> share any good script
>
> 2. Is it good to Shrink the table or Reorganize it using CTAS or
> dbms_redefinition.
>
> TIA
> Sanjay
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
