Re: Average space need

From: Edward Jayaraj <reddyma_at_chorus.net>
Date: Fri, 12 Feb 1999 15:28:02 -0600
Message-ID: <7a268i$oho$1@news.itis.com>

Try using the VSIZE(column_name), that will give you the size (bytes) of the data column in each row. You can use this to find the average.

Edward Jayaraj
pejayaraj_at_hotmail.com

Mark McHugh wrote in message <79r5m4$nj112_at_atbhp.corpmel.bhp.com.au>...
>There is a function in TOAD (even the free version) that calculates how
much
>space a row takes and lets you estimate the size of a table - it's under
the
>tuning menu :
>
>http://www.toadsoft.com
>
>regards,
>Mark.
>
>
>Victor Zwimpfer wrote in message <78n404$qkp$1_at_news.imp.ch>...
>>Hi,
>>
>>Is there a possibility to find out, how much space (average value) is used
>>by a row in a table? I need to evaluate the average space need for an
>>address ( a relationship of ca. 5 tables).
>>
>>thank you
>>Victor
>>
>>
>
>
Received on Fri Feb 12 1999 - 15:28:02 CST