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

On Aug 21, 10:47 am, sybra..._at_hccnet.nl wrote:
> On Thu, 21 Aug 2008 07:38:11 -0700 (PDT), EliasFigueroa
>
> <Eliasf..._at_gmail.com> wrote:
> >What are the advantages of migrating appliations from Oracle 8i to the
> >10g platform
>
> 10g is more stable, it requires less maintenance, and less down-time
> (more can be changed dynamically, some parameters are auto-tuned).
> You have more options to diagnose problems, and/or to be advised by
> Oracle to take certain measures.
>
> Apart from that, there is that one key feature: Support.
> Oracle 8i is in sustained support, which means you will still get
> patches for known problems, and in all other cases Oracle will dump
> the phone on you.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Support as Sybrand said it the main benefit of upgrading. Upgrading will also make all the new 10g features including those added in 9i available to your development and DBA teams. Bulk loading in PL/SQL and regular expression searches in 10g are just two of the new/ imporved features that might be of interest.

The New Features Guides for 9i and 10g might be work a quick review.

HTH -- Mark D Powell -- Received on Thu Aug 21 2008 - 10:24:05 CDT