FAQ
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.

Search Discussions

  • Taylor, Chris David at Aug 25, 2011 at 2:07 pm
    Nevermind...I found it.

    Thanks!

    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.

    From: oracle-l-bounce_at_freelists.org On Behalf Of Taylor, Chris David
    Sent: Thursday, August 25, 2011 8:56 AM
    To: 'oracle-l@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.
  • Powell, Mark at Aug 25, 2011 at 2:12 pm
    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 On Behalf Of Taylor, Chris David
    Sent: Thursday, August 25, 2011 9:56 AM
    To: 'oracle-l@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.
  • Mark W. Farnham at Aug 25, 2011 at 7:10 pm
    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
    On Behalf Of Powell, Mark
    Sent: Thursday, August 25, 2011 10:13 AM
    To: 'oracle-l@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
    On Behalf Of Taylor, Chris David
    Sent: Thursday, August 25, 2011 9:56 AM
    To: 'oracle-l@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.
  • Goulet, Richard at Aug 29, 2011 at 1:25 pm
    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 On Behalf Of Taylor, Chris David
    Sent: Thursday, August 25, 2011 9:56 AM
    To: 'oracle-l@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.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedAug 25, '11 at 1:56p
activeAug 29, '11 at 1:25p
posts5
users4
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase