Space Estimation Performance (numbers)

2001-05-21 Thread Walter K
Hi, How do I calculate the amount of physical space required for storing a number? (i.e. NUMBER, NUMBER(5), NUMBER(10,5), etc.) I believe Oracle uses 2's compliment for storing numbers. A value of 1 does not seem to take up the same amount of space as 9. TIA! -wk

RE: Space Estimation Performance (numbers)

2001-05-21 Thread Toepke, Kevin M
Walter: You use the VSIZE() function. And you are right about 1 not taking the same amount of size as 9. 1 uses 2 bytes and 9 uses 4. SQL select vsize(1), vsize(9) from dual; VSIZE(1) VSIZE(9) 24 Kevin