RE: avg_space field in DBA_TABLES

From: POWELL, MARK <mark.powell2_at_hp.com>
Date: Wed, 28 Oct 2009 14:26:14 +0000
Message-ID: <7C4BF3B32B80CC44AE37D31B172415933A5B9D8701_at_GVW1337EXC.americas.hpqcorp.net>


 

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: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Chen Shapira Sent: Tuesday, October 27, 2009 1:17 PM
To: Surachart Opun
Cc: gerwin.hendriksen_at_gmail.com; oracle-l Subject: Re: avg_space field in DBA_TABLES

On Tue, Oct 27, 2009 at 3:08 AM, Surachart Opun <surachart_at_gmail.com> wrote:
> AVG_SPACE column filled in by ANALYZE but not dbms_stats
>
> http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:43
> 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.

Chen

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


--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 28 2009 - 09:26:14 CDT

Original text of this message