On Apr 3, 2:31 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "MTNorman" <mtnor..._at_duke-energy.com> a écrit dans le message de news: 1175623636.920607.146..._at_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.
> |
>
> column and row headers.
>
> Regards
> Michel Cadot
The row header is 13 bytes for this table using the Note 10640.1
formula - so the 5 bytes difference should not be the row header.
Received on Wed Apr 04 2007 - 06:32:41 CDT
