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

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle data types & sizes

Re: Oracle data types & sizes

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Mon, 15 Jan 2001 06:25:55 GMT
Message-ID: <TJw86.265257$U46.8545596@news1.sttls1.wa.home.com>

You can use vsize to determine how much room something actually takes up. select vsize(myNumber) from mytable;
Numbers are stored in base 100 with an addition of a sign byte. So (log(theNumber)/2)+1 Based on the actual percision of the number. There is a package dbms_space that can give you a lot of storage information. Also the dba_segments table. Jim

"Mike DiChiappari" <mike_at_mysticsoft.com> wrote in message news:93u0a5$h7g_at_freepress.concentric.net...
> Two related questions:
>
> 1) How does Oracle store Numbers (integers in particular)? How much space
> (in bytes) does a Number(38,0) take up.
>
> 2) Is there a way to determine how much space in a datafile (or
 tablespace)
> is consumed by each user (or table)?
>
> Thanks,
> Mike
>
>
>
Received on Mon Jan 15 2001 - 00:25:55 CST

Original text of this message

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