RE: Anyone know off the top of their head where can I find data type STORAGE calculations for the Oracle data types?

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Thu, 25 Aug 2011 15:10:51 -0400
Message-ID: <094901cc635a$b55fc260$201f4720$_at_rsiz.com>



The vsize function can be used on actual values (except that it returns NULL for NULL, instead of the actual amount of storage taken up by the NULL).  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Powell, Mark
Sent: Thursday, August 25, 2011 10:13 AM To: 'oracle-l_at_freelists.org'
Subject: RE: Anyone know off the top of their head where can I find data type STORAGE calculations for the Oracle data types?  

Not very specific  

A date column takes 7 bytes of storeage  

A number data type is approximately the size of the following formula  

The length can be calculated as:
 p = number of digits in value
 s = 0 for positive number and 1 for a negative number  

round((( length((p) + s) / 2)) + 1  

Values of powers of 10 would take less space than calculated.  

Every row is going to have a 3 byte row header plus you have the fixed and variable bock overhead to account for and null indicators.    


From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Taylor, Chris David
Sent: Thursday, August 25, 2011 9:56 AM
To: 'oracle-l_at_freelists.org'
Subject: Anyone know off the top of their head where can I find data type STORAGE calculations for the Oracle data types?

I need to be able to calculate a row's worth of data STORAGE for DATE & NUMERIC columns.      

Chris Taylor

Sr. Oracle DBA

Ingram Marine Group

Nashville, TN 37205

Office: 615-517-3355

Cell: 615-663-1673

Email: chris.taylor_at_ingrambarge.com  

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.  

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 25 2011 - 14:10:51 CDT

Original text of this message