Re: How to estimate Oracle rdbms volumes from vsam legacy system

Hi,
Also have a look at Oracle7 Server Space Management white paper at www.orafns.com/whtpaper.html
It has a nice explanation of how oracle manages the space. And also how to size the database tables, indexes and clusters. I have created a excell spreadsheet which gives me the sizing information of the tables that I have had to convert from the RMS files on VMS to Oracle.

Ketan Shah

In article <6dlma5$ftr$1_at_news00.btx.dtag.de>,   GreMa_at_t-online.de wrote:
>
> On Wed, 04 Mar 1998 22:03:27 -0600, vfoster2_at_aol.com wrote:
> Hi,
>
> take a look into either:
>
> 'DBA Handbook' written by Kevin Loney
>
> or
>
> 'Tuning Oracle' written by Corey, Abbey, Dechichio
>
> both published by Oracle Press/Osborne.
>
> They both contain algorithms and examples how to estimate the right sizes
 of your db-objects.
>
> >Help!!
> >
> >I have converted a legacy mainframe system (4 gig) to an Oracle rdbms
> >database. The estimated factor of conversion was the mainframe data volume
> >times 3. The actual was 6 (25 gig).
> >
> >Are there any good methodologies or metrics to measure this more
 accurately?
> >I will begin converting another legacy system soon. This one dwarfts the
> >first in mainframe data volumes by 5. How can I estimate the Oracle data
> >volumes? (20 * 6=120 gig!!) How can I estimate CPU, memory, etc that will
> >get through budget approval but also be realistic??
> >
> >Our current platform is HP_UX 10.20, Oracle 7.3.4. We will stay with
 Oracle
> >but not necessarily HP.
> >
> >Any input would be appreciated!!!
> >
> >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> >http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
> --
>
> Regards
>
> Matthias Gresz :-)
>
> GreMa_at_T-online.de
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Mar 06 1998 - 00:00:00 CST