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

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: "ChrisDavid.Taylor@xxxxxxxxxxxxxxx" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 29 Aug 2011 13:25:47 +0000

Assuming you have some sample data, the best one is to review the function 
vsize.

Richard Goulet
Senior Oracle DBA/Na Team Leader

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: