Re: Minimum bytes of storage for each data type

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 24 Nov 1999 20:51:29 +0800
Message-ID: <383BDF51.2A1E@yahoo.com>

sriviswa_at_hotmail.com wrote:
>
> Hi,
>
> Is there a minimum bytes of storage that oracle would use for each data
> type irrespective of the data within. For example, I have a NUMBER(3)
> column. The DATA_LENGTH and DATA_PRECISION in the USER_TAB_COLUMNS
> show 22 and 3 respectively. Which one should I use for calculating
> row lengths. Thanks.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Check V$TYPE_SIZE

Also in Server Concepts ( I think) it shows you how to calculate storage used. Also have a look at the VSIZE function.

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Nov 24 1999 - 06:51:29 CST