Home -> Mailing Lists -> Oracle-L -> RE: Anyone know off the top of their head where can I find data type STORAGE calculations for the Oracle data types?

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_at_parexel.com>
Date: Mon, 29 Aug 2011 13:25:47 +0000
Message-ID: <7642C3D639A75E4284658CAA38BF60A40251D9_at_US-BOS-VEX001.eu.pxl.int> 





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_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<mailto: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-l


Received on Mon Aug 29 2011 - 08:25:47 CDT












Original text of this message