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).
On Behalf Of Powell, Mark
Sent: Thursday, August 25, 2011 10:13 AM
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.
On Behalf Of Taylor, Chris David
Sent: Thursday, August 25, 2011 9:56 AM
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 &
Sr. Oracle DBA
Ingram Marine Group
Nashville, TN 37205
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.