Re: avg_space field in DBA_TABLES
From: Chen Shapira <cshapi_at_gmail.com>
Date: Tue, 27 Oct 2009 10:17:14 -0700
Message-ID: <e37540930910271017y1cdb6668sf45861744fac9f75_at_mail.gmail.com>
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:4347359891525
>
Date: Tue, 27 Oct 2009 10:17:14 -0700
Message-ID: <e37540930910271017y1cdb6668sf45861744fac9f75_at_mail.gmail.com>
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:4347359891525
>
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-lReceived on Tue Oct 27 2009 - 12:17:14 CDT