Help - Size of number field

Help - Size of number field

 

  

We will have a teble which will store billions of records. We are very
concerned with each byte that is taken up in this table. Can anyone provide
input on how many bytes is taken up by the following. As well, if you have a
pointer to documentation on actual space taken by the data types - I have
been looking unsuccessfully in OTN on 8i.

INT
SMALLINT
NUMBER(2)

Thanks,
Colin


Oracle LazyDBA home page