Re: avg_space field in DBA_TABLES

From: Chen Shapira <>
Date: Tue, 27 Oct 2009 10:17:14 -0700
Message-ID: <>

On Tue, Oct 27, 2009 at 3:08 AM, Surachart Opun <> wrote:
> AVG_SPACE column filled in by ANALYZE but not dbms_stats

Thanks, Surachart. This indeed solved the issue. I thought DBMS_STATS is the same as ANALYZE... but now I know better!

> But what wrong with my "AVG_ROW_LEN" column

I wonder about that as well.
My avg row length is 31 with dbms_stats, 35 with analyze, and 29.8 when I compute it myself using vsize. Its not a big or meaningful difference, but I wonder what are they doing differently.


Received on Tue Oct 27 2009 - 12:17:14 CDT

Original text of this message