Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to calculate the memory required for data ?

How to calculate the memory required for data ?

From: Arnold Schommer <aschommer_at_fs-edv.de>
Date: Fri, 04 Dec 1998 08:30:40 +0100
Message-ID: <36678FA0.67C835C1@fs-edv.de>


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 ?

I ask my question for several reasons:
* curiosity

Has someone experience, heard of a tool or so ?

Thanks in advance

Arnold Schommer Received on Fri Dec 04 1998 - 01:30:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US