Re: average row length for a table

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 3 Apr 2007 20:31:21 +0200
Message-ID: <46129d78$0$29105$426a74cc@news.free.fr>

"MTNorman" <mtnorman_at_duke-energy.com> a écrit dans le message de news: 1175623636.920607.146360_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 Received on Tue Apr 03 2007 - 13:31:21 CDT