You haven't allowed for column length bytes
(1 per column usually, but 3 for columns over
254 bytes) or the row header (3 bytes).
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
John Dorlon wrote in message ...
>Does anyone know why this query....
>
>Select
>AVG(
> NVL(VSIZE(col1),0) +
> NVL(VSIZE(col2),0) +
> NVL(VSIZE(col3),0)) "Average Row Length"
>from table1
>
>would yield different results than the AVG_LEN column in DBA_TABLES after
an
>'analyze table table1 compute statistics'?
>
>(yes I am including all of the columns in my query and the statistics on
the
>table are current)
>
>Thanks in Advance!
>
>-John
>
>
>
>
Received on Sun Jan 07 2001 - 02:34:43 CST
