RE: avg_space field in DBA_TABLES
Date: Wed, 28 Oct 2009 14:26:14 +0000
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.
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
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.
ChenReceived on Wed Oct 28 2009 - 09:26:14 CDT