Re: datatype sizes

In <321E8AC5.6CE1_at_teldta.com> "Brian P. Mac Lean" <brian.maclean_at_teldta.com> writes:
>
>gshell wrote:
>>
>> Can anyone point me to a manual reference that gives the byte
>> requirements for each of the Oracle datatypes. I'm trying to
 estimate
>> the disk space requirements for a database. I've found the "higher
>> level" formulas that calculate the files size based on a row of a
>> given size. But they show NADA on how to calculate the row size.
>> Specifically, I need the size for a DATE and a NUMBER. I assume,
>> given that a NUMBER datatype can handle up to 32 significant digits,
>> it must be at least 16 bytes. (If I did my math corrrectly. <big ole
>> grin>)
>>
>> Thanks,
>>
>> Gary Shell
>
>I don't have the manual in front of me here so I'm wing'en this one.
>Create a sample table and a few rows. Do an analyze on the table.
>The dba_tables view should now have some info of the average size of
>a row in your table. The sql ref also documents two functions, "dump"
>and "vsize". I'm sure one of these will give you the real size of
>any column.
>
> \\|//
> (0-0)
> +-----oOO----(_)-----------+
> | Brian P. Mac Lean |
> | Database Analyst |
> | brian.maclean_at_teldta.com |
> | http://www.teldta.com |
> +-------------------oOO----+
> |__|__|
> || ||
> ooO Ooo

For Oracle7, see Chapter 8, Managing Schema Objects, of the Server Administrator's Guide (SAG) for calculating the space required for tables, indexes, etc. based on column datatype and estimated average length.

Hope this helps.

Jim Reynolds
jbreynol_at_ix.netcom.com Received on Sat Aug 24 1996 - 00:00:00 CEST