RE: Varied block density for fixed length row tables
From: Yong Huang <yong321_at_yahoo.com>
Date: Thu, 15 Sep 2011 11:07:30 -0700 (PDT)
Message-ID: <1316110050.14112.YahooMailClassic_at_web80606.mail.mud.yahoo.com>
> Of course, *now* I managed to find the storage formula for NUMBER
> ("Internal Numeric Format" heading):
>
> http://download.oracle.com/docs/cd/B14117_01/server.101/b10743/datatype.htm#i16209
Date: Thu, 15 Sep 2011 11:07:30 -0700 (PDT)
Message-ID: <1316110050.14112.YahooMailClassic_at_web80606.mail.mud.yahoo.com>
> Of course, *now* I managed to find the storage formula for NUMBER
> ("Internal Numeric Format" heading):
>
> http://download.oracle.com/docs/cd/B14117_01/server.101/b10743/datatype.htm#i16209
Speaking of storage of number data type, Oracle's formula has been wrong for 10 years or longer, and was finally dropped in 11gR2 documentation. See
http://yong321.freeshell.org/oranotes/NumberDataStorageLength.txt
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 15 2011 - 13:07:30 CDT