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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Taylor, Chris David
Sent: Thursday, August 25, 2011 9:56 AM
To: 'oracle-l@xxxxxxxxxxxxx'
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@xxxxxxxxxxxxxxx<mailto:chris.taylor@xxxxxxxxxxxxxxx>

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.

Other related posts: