Home » RDBMS Server » Server Utilities » Space utilisation for number.
Space utilisation for number. [message #198967] Thu, 19 October 2006 07:38 Go to next message
msgforsunil
Messages: 26
Registered: November 2005
Junior Member
Hi All,

After creating the following table.

create table NUMBERTEST (x integer, y number(38), z number(20,0), w number(2)) ;

If you see that y is declared as number(38). Would each value in this field actually occupy 38 bytes or would it occupy only it needs? In the sense would it behave like varchar2?


By the way, how do I find the space utilisation for a table?

Thanks,
Sunil
Re: Space utilisation for number. [message #199052 is a reply to message #198967] Thu, 19 October 2006 20:33 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
It only occupies the space it needs. You can measure the space used by any value with the VSIZE() function.

Ross Leishman
Re: Space utilisation for number. [message #199257 is a reply to message #199052] Sun, 22 October 2006 22:55 Go to previous message
msgforsunil
Messages: 26
Registered: November 2005
Junior Member
Thanks. Will look into VSIZE() functionality.
Previous Topic: Getting to know size of tables from Dump?
Next Topic: How to load substr via sql loader
Goto Forum:
  


Current Time: Thu Dec 08 12:07:47 CST 2016

Total time taken to generate the page: 0.06103 seconds