Re: Average Row Length...

From: Mark D Powell <mark.powell_at_eds.com>
Date: 18 Apr 2002 06:58:08 -0700
Message-ID: <178d2795.0204180558.7b5ad624@posting.google.com>

"ARP" <sirapitt_at_hotmail.com> wrote in message news:<ubs2t4i8s05qd0_at_corp.supernews.com>...
> Is there a known algorithm for calculating average row length on various
> tables in an Oracle database and, if there is such a beast, can someone
> share it with me?
>
> Thanks.

There are numerous articles related to this topic on metalink (meatalink.oracle.com) but none which specifically state how Oracle calculates the average row size when you use the analyze command or dbms_stats.

Article How to Retrieve Statistics Generated by ANALYZE SQL Statement Doc ID: 122009.1 may be of interest if you are new to Oracle.

While the article SCRIPT TO CALCULATE TABLE ROW SIZE id 1019507.6 stats that for tables with no long (or LOBS) or object columns you can basically:

select round(avg(nvl(vsize(col1),0))) + round(avg(nvl(vsize(col2),0))) ....

to calculate the average row size.

HTH -- Mark D Powell -- Received on Thu Apr 18 2002 - 08:58:08 CDT