RE: Anyone know off the top of their head where can I find data type STORAGE calculations for the Oracle data types?
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Aug 2011 15:12:41 +0100
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:
