Re: Database sizeing question - so how big is a number anyway?

From: Jos <jga.wolters_at_abp.nl>
Date: 2000/06/21
Message-ID: <8ips39$c57@abp.nl>#1/1

Hi Ken,

The size of a number field is 22 bytes in an index an it depends on the number of digits in the numer field in the table data.

The rule is that the size is round(#digits / 2) + 1. You can see the size with the "dump" function.

select dump(1234567) from dual;

DUMP(1234567)

---

Typ=2 Len=5: 196,2,24,46,68
1 row selected.

Bye,
Jos

ken k <khkachn_at_toadDIESPAMMER.net> schreef in berichtnieuws H%S35.482$BA1.1000118_at_news.abs.net...
> 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
>
>
Received on Wed Jun 21 2000 - 00:00:00 CDT