Re: STORAGE (INITIAL <SIZE>)?

>
> ORACLE-L Users,
> I have spent considerable time struggling with understanding
> Oracle's formula for determining the STORAGE (INITIAL <size>) value
> for Tables and Indexes. Oracle7 Administrator's Guide devotes 5 pages
> in chapter 8 to the process for Tables. I managed to decifer it to
> the best of my ability and placed the formula in an Excel spreadsheet.
> The results appear to me to be on the high side.
>
> I also recognize that these are "estimates" and a part of the
> "Tuning" process and in a production environment require regular
> monitoring/tweeking.
>
> Are there any other formulas or tools out there that I might try?
>
> Thank you for your help.
>
> gerald_bowers_at_fmso.navy.mil
>

Hi Gerald,

     CASE*DICTIONARY has an option to do sizing. But this just generates a report which can be used for estimating the entire DB size. If you want to use the size info to decide upon INITIAL and NEXT storage parameters, it might not be a suitable option.

      We have written PL/SQL procedures based on the Oracle manual to estimate sizes and store the result in a table. This is then used by a script to alter the DDL's generated by CASE to include suitable INITIAL and NEXT parameters. As for as my experience goes, the procedures gave a better approximate for tables. But for indexes, the procedures gave a lower estimate and the CASE output was more closer to the actual size.

      There should be some third party tools for this I suppose. Anybody  knows about such tools ?

Thanks,
Rukmani. Received on Mon Jan 08 1996 - 07:03:35 CST