Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database sizeing question - so how big is a number anyway?
22 bytes
-- Robert Fazio, Oracle DBA rfazio_at_home.com remove nospam from reply address http://24.8.218.197/ "ken k" <khkachn_at_toadDIESPAMMER.net> wrote in message news:H%S35.482$BA1.1000118_at_news.abs.net...Received on Wed Jun 21 2000 - 00:00:00 CDT
> Hi all,
>
> I am trying to come up with some predictions on how much disk
> space a table and index is going to take. The table has one date field
> (7 bytes, found that one) and some number(10,0) and number(5,0)
> fields.
> I found the Oracle documentation on how to estimate a table and
> index size but have not idea how many bytes the number fields will
> take. The documentation seems to think you are estimating the size
> of an existing table, which is dumb IMHO. Does anyone know how
> the size works for number data type?
>
> Thanks,
>
> Ken K
>
>