Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> average row length for a table

average row length for a table

From: MTNorman <mtnorman_at_duke-energy.com>
Date: 3 Apr 2007 11:07:17 -0700
Message-ID: <1175623636.920607.146360@w1g2000hsg.googlegroups.com>


What's the difference between the vsize query below (from MetaLink Note 10640.1) and the dba_tables.avg_row_len value calculated using dbms_stats compute?

SELECT AVG(NVL(VSIZE(A), 1)) +
AVG(NVL(VSIZE(B), 1)) +
AVG(NVL(VSIZE(C), 1)) "SPACE OF AVERAGE ROW" FROM test;

On one 46 million row table, the vsize query returns 57 and dbms_stats computes 62 as the avg_row_len. Version 9.2.0.6 on AIX 5.3 in an uniform extent LMT with manual segment space management. Received on Tue Apr 03 2007 - 13:07:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US