Re: space usuage of number datatype

Do the following select statement on some (or all) your numeric fields.

select avg(vsize(column_name)) column_name_size from table_name;

This will give you the average physical storage required for a field (numeric or not)....

Regards,

Marc Mazerolle
InforMaze Inc.

gongji_at_my-deja.com wrote:

> Hello:
> I have one question about space usuage of number datatype
> column. I was told that the database assigns a number datatype as
> fixed space, for example, 21 bytes, nomatter how small digital in
> number column.
> I have lots of table which contains lots of numeric column,
> but each column has very small digits. If Oracle database really
> assigns the numeric column like that, my tables eat huge space.
> I know database can smartly assign space to the varchar
> column, that is if the varchar length is small, it gives a small
> space, if varchar length is big, it gives more. I am just wondering
> whether database also treats number datatype column like that?
> Does someone know this?
> Thank you very much.
>
> Jin
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Tue Jun 29 1999 - 11:55:43 CDT