Converting to Oracle
Posted 05 November 1999 - 06:46 PM
Yes, Glovia have a set of tools which are pretty good. BUT it's not difficult to do it all yourself, simply a matter of converting the FD's to Oracle sensibly and having a GOOD DBA to do the Oracle stuff.
Be careful with odometers and look hard at functions which perform multiple reads and sorts as they will be very inefficient under ORACLE.
I've just been through the process here at Dell (also on VMS) so if you want any other help let me know!
Posted 09 November 1999 - 03:05 AM
1) Double you machine capacity, we went from a RS6000 590 to a RS6000 F50 using the fastest possible CPU chips and it still runs slower than ordinary ProIV ISAM
2) Double you disk capacity, Oracle is very hungry.
3) Conversion was a real pain. You must correctly size your tables and load the data using SQLLoader.
Any more points required please Email me.
Posted 19 December 1999 - 10:20 PM
Try and involve someone with some experience of tuning Oracle or (knowing how hard it is to get those people) study a couple of the books on the subject. It is a big help to avoid spurious performance problems due merely to configuration.
Keep the database on the same machine as the Pro-IV application.
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users