Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: What really is NUMBER under the covers
Ken Sproule wrote in message ...
>I would like to thank everyone in advance for your help.
>
>My question is simply that I need to know exactaly what Oracle does
>with a NUMBER(10,2) internally. I mean, How much space is actually
>consumed on the disk in storage AND where is this documented.
>
In the one of the appendices of the administrators guide (might be the server reference) it tells you how to estimate rowsize for objects based on field sizes, some constants you can find in a v$ view and a few rules of thumb. I believe the column lengths come from dba_tab_columns. Received on Thu Feb 03 2000 - 19:04:46 CST
![]() |
![]() |