Oracle object storage calculation: Worst or average?

   Hello,

  I´m doing a job of calculate oracle storages values for tables and indexes. I have read oracle documentation. Oracle claims that I have use a select with avg(vzise(column)) for all columns of table and index to calculate row size and column size for indexes.

   But this is effective only when I have the table already created with good sample values inserted. And this give me evaluations of averages values. I´m trying calculate the worst case. In others words, the maximum occuped tables and indexes storage to do pre allocation in tablespaces.

   I´m trying use the data_lenght and columns_length of user_tab_columns and user_ind_columns to do the row size for tables and all column sizes for indexes. But this is only working if char and varchar2 values.

   With number values the results are too much bigger than maximum! In an number columns, the data_length values is always 22, regardless the precision of the number.

  How can I do, in a select, to get these values correctly for all data types?

   Best regards
   Luis Santos

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Nov 24 1998 - 13:19:28 CST