Re: Regarding Oracle version upgrading questions
Date: Mon, 26 Jan 2009 07:46:22 -0800 (PST)
On Jan 26, 10:07 am, "jshen...._at_gmail.com" <jshen...._at_gmail.com> wrote:
> we are considering seriously on upgrading our database server.
> Current database runs on HP-UX 11.11, 20CPU and 36GB RAM. The
> version is Oracle8.1.7.
> To system running records, we met Ora-600 error frequently. There
> is always sequent read and latch waiting in system. We also found, if
> we allocate more DRAM to shared pool the overall performance degrades.
> There exist debate on upgrading Oracle8.1.7 to higher version. Some
> guys says there should be little internal technique improvement, and
> oracle10g , oracle11g only improve with management tools which just
> means alot to business analysis. While kernel algo. and mechanism did
> not improve at all.
> We'd like hear from those who have upgrade their oracle server ,
> 1. did oracle 10g or oracle11g just mean to improve business report
> 2. did oracle 10g and oracle11g improve with performance?
> 3. did oracle 10g and oracle11g improve with reliablity and
> monitoring tools ?
> each word will be highly appreciated !
This is not a direct reply to your questions, but more a pointer to get you started.
Take a look at the following, which shows what to expect with an
upgrade from Oracle 9i to 10g R2 - some of which will apply to your
situation also with an upgrade from 8i:
If you are able to locate a copy of "Cost-Based Oracle Fundamentals", read through Appendix A to see an overview of what internal optimization changes have happened from one version to the next.
Finally, try the following Google search: http://www.google.com/search?q=site%3Ajonathanlewis.wordpress.com+upgrade
You might also try this Google search to find the what's new
documentation on Oracle's site:
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Mon Jan 26 2009 - 09:46:22 CST