Re: Help: Average Record Size

Check out the oracle example, pg 8-20 in the Oracle 7 Server Admin. Guide:  

SELECT AVG(NVL(VSIZE(col1),0)) + AVG(NVL(VSIZE(col2),0)) + etc...   "Space of Avg Row" from table1;  

Regards,
Steve Cosner  

In article <DJHC4t.628_at_epsilon.com> Bob D'Amore <bdamore_at_epsilon.com> writes:
>
>I've got a v7 database and i'm trying to figure out the
>average record size of each table. I havent been able to
>come up with a solution. I can figure out extent size and #
>of extents, but i cant figure out how to get the % of free
>space in a table's extents. Help! Thanks.
>
>-bdamore_at_epsilon.com
  Received on Tue Dec 12 1995 - 00:00:00 CET