Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re:AVG_ROW_LEN
-----Original Message-----
From: dgoulet_at_vicr.com <dgoulet_at_vicr.com>
Subject: Re:AVG_ROW_LEN
> I do not believe that the AVG_ROW_LEN column contains any thing other
than
>the actual average row length. At least comparisons of the
>avg(vsize()+vsize()...) and AVG_ROW_LEN bear that out.
Thanks for resonding, however I tested it after I sent the message (I know, wrong order). My test (8.0.5) suggests that AVG_ROW_LEN includes both the byte length overhead and the row header overhead. Besides, I read that AVG_ROW_LEN includes overhead in an Oracle document, so it must be true ;o). The document didn't specify if both the row header + and column overhead were incuded, which is why I asked the question.
EXAMPLE:
Table created.
oradba> insert into test_space values (1234.99, 'Go Crew!');
1 row created.
oradba> analyze table test_space compute statistics;
Table analyzed.
oradba> select avg(vsize(test1)+vsize(test2)) from test_space; Received on Fri Jul 07 2000 - 17:42:06 CDT