Re: Regarding Oracle version upgrading questions
Date: Mon, 26 Jan 2009 07:46:22 -0800 (PST)
Message-ID: <20e17a40-a48c-4233-b8a2-e32e7d35d1ce_at_r37g2000prr.googlegroups.com>
On Jan 26, 10:07 am, "jshen...._at_gmail.com" <jshen...._at_gmail.com> wrote:
> hi,
>
> 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 ,
> that
>
> 1. did oracle 10g or oracle11g just mean to improve business report
> tools?
>
> 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 !
>
> Joe
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:
http://www.oracle.com/technology/products/bi/db/10g/pdf/twp_bidw_optimizer_10gr2_0208.pdf
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:
http://www.google.com/search?q=site%3Adownload.oracle.com+upgrade+database+whats+new
Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.
Received on Mon Jan 26 2009 - 09:46:22 CST