Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How many bytes does the number data type take internally?
> How do you calculate it?
There is a function VSIZE that returns the bytes allocated by an entry.
You'll have to use something like AVG(VSIZE(my_column)) to get an usable
value.
Hth
Joerg
Received on Wed Jul 14 1999 - 07:18:52 CDT