Re: How to calculate the memory required for data ?

Hi,

This is a very helpful site

Thanks to Mark.

DPL-00814 wrote in message <3667C34D.B8D3B50E_at_DerPatriot.com>...
>Take a look at Mark Lang's Home Page at
>http://www.geocities.com/SiliconValley/Lakes/1261/
>and download the SQL Library.
>In there are several brilliant scripts witch show you everything you need
to
>answer your question.
>
>Bye
>Andreas Koester
>
>
>Arnold Schommer schrieb:
>
>> Simple Question: How to find out, how many bytes of the disk some data
>> in a table requires ?
>>
>> There are several things i do not know:
>> * how many bytes does one column of a certain datatype (NUMBER(n,m),
>> VARCHAR2(n), DATE, ...) require ?
>> * is there (and if, how large) some overhead for each column that is not
>> null ?
>> * how large is the overhead for an entire row ?
>> * how large are the overheads for a database block and a table extent ?
>> * what about indices ?
>> * what did i forget ?
>>
>> I ask my question for several reasons:
>> * curiosity
>> * when i want to create a table/index, many books ask me how large the
>> table/index (or one row) will be to calculate the storage parameters
>> * when customizing pctfree/pctused, i have to know how "large" at least
>> an average row is
>>
>> Has someone experience, heard of a tool or so ?
>>
>> Thanks in advance
>>
>> Arnold Schommer
>
>
>
Received on Fri Dec 04 1998 - 12:36:20 CST