Re: Tables Size

From: G <andrew.kerber_at_gmail.com>
Date: Thu, 17 Nov 2011 07:33:18 -0600
Message-Id: <058C2B33-BA73-4AFE-84C8-C104DAABCD8F_at_gmail.com>

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_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. 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
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

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

Received on Thu Nov 17 2011 - 07:33:18 CST