Re: What are the advantages of migrating appliations from Oracle 8i to the 10g platform?

On Aug 21, 6:38 pm, EliasFigueroa <Eliasf..._at_gmail.com> wrote:
> What are the advantages of migrating appliations from Oracle 8i to the
> 10g platform

If your applications don't evolve and "just work", probably none. You may get some performance improvements from migrating, but you may well get all sorts of problems, slowdowns and incompatibilities if your PL/ SQL code is quirky and your SQL is not CBO-friendly and you didn't account for the new features in it, or if your application was built using some old framework or platform. Sybrand's and Mark's points do apply, but to a degree.

For example, we have an application that was written using Forms6i. The app was certified against 8i and later 9iR2, but that's it. No 10g or 11g, it simply won't work with these releases. Forms client can't even use 9i client, it has to use its own v8 client. The app can't be changed, nor can it be replaced, so there's no reason for us to migrate in this case (unless we want to break it and train ourselves in overnight DR. :))

Support is important, but if your application is working fine and you didn't have any new issues with Oracle8i for the last 4 years that required support calls then what difference will another 4 years without support make? Besides, you can still get support, just not the bug fixes - but most probably none will be needed anyway.

"Better is the enemy of good."

                    Voltaire

Regards,

   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)    http://www.dynamicpsp.com Received on Fri Aug 22 2008 - 01:09:42 CDT