Re: How to calculate the memory required for data ?

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 - 05:11:09 CST