On Oct 20, 2:30 am, "jshen...._at_gmail.com" <jshen...._at_gmail.com> wrote:
> > You realize that Oracle 9i is desupported as well? Provided that you are on
> > a support contract, Oracle upgrades are free.
>
> Oracle9i is supported by Infranet 6.5.
>
> What I'm considering is , will it be more valuable to upgrade
> Oracle than just adding more DRAM.
>
> To some post in this list before, Oracle10g's performance is about
> four times of Oracle8i.
>
> How much performance improvement could we expect to Oracle9i ?
>
> Joe
It all depends on why your performance is lagging now. Upgrading
won't relieve any existing i/o contention, it won't relieve any
saturation of the i/o channels or the network, it (generally) won't do
anything about a poorly designed app or poorly written SQL. Sometime
the newer optimizer generates better plans .. but then sometimes it
generates worse plans....
Received on Sat Oct 20 2007 - 07:01:05 CDT
