Re: How to estimate diskspace needed...?

Hi Kelly,

The algorithms for sizing tables and indexes are in Appendix A of the Server Administrators guide and tend to give fairly good results.

It is also possible to employ the cheap and dirty method of comparing your current storage requirements for n rows and multiplying it by m/n where m is the expected number of rows. If you do this, it is important that you check that the data you curently have (column population and size of variable length columns) is representative of the data you intend to obtain.

Issuing the command;

select segment_name,segment_type,bytes from dba_segements;

will tell you how much space is ALLOCATED to each segment (table,index etc) within your database but not how much is actually used. If you think your current allocations are too large you can use the DBMS_SPACE package to find out how much is actually being used (I can provide more help on this if you wish)

Hope this helps,

Ian Received on Mon Nov 10 1997 - 00:00:00 CST