RE: avg_space field in DBA_TABLES

Date: Wed, 28 Oct 2009 14:26:14 +0000
Message-ID: <>


The difference in the avg_row_len is the 3 byte row header. DBMS_STATS does not account for it while the ANALYZE command always has.

-----Original Message-----
From: [] On Behalf Of Chen Shapira Sent: Tuesday, October 27, 2009 1:17 PM
To: Surachart Opun
Cc:; oracle-l Subject: Re: avg_space field in DBA_TABLES

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

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 Wed Oct 28 2009 - 09:26:14 CDT

Original text of this message