The Oracle (tm) Users' Co-Operative FAQ

How much space does a number take up.


Author's name: Jonathan Lewis

Author's Email: Jonathan@jlcomp.demon.co.uk

Date written: 26th July 2001

Oracle version(s): 7.3 - 8.1.7.0

It is possible to define a number so that it is stored in the database with 38 digits of precision. If I do this, how much space does a number really use if it doesn't actually use this degree of precision. Strangely, the internal storage for number (dba_tab_columns) suggests that the worst case usage for a number is 22 bytes, so how much space does it really take to store a number ?.

Back to index of questions


.


Further reading: N/A


Back to top

Back to index of questions