Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle data types & sizes
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