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

Home -> Community -> Usenet -> c.d.o.misc -> Re: What really is NUMBER under the covers

Re: What really is NUMBER under the covers

From: Mark Hodges <mark_at_hodges-technologies.co.uk>
Date: Fri, 4 Feb 2000 01:04:46 -0000
Message-ID: <87d8ln$j9d$1@gxsn.com>


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

Original text of this message

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