RE: Anyone know off the top of their head where can I find data type STORAGE calculations for the Oracle data types?
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-lReceived on Thu Aug 25 2011 - 14:10:51 CDT