Re: Regarding Oracle version upgrading questions

On Jan 26, 10:07 am, "jshen....@xxxxxxxxx" <jshen....@xxxxxxxxx>
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?

Oracle corp put a lot more into each release past 8.1.7 than just
improving business reporting tools.

  2. did oracle 10g and oracle11g improve with performance?

Certainly but mileage will vary based on what features of Oracle you
use.

  3. did oracle 10g and oracle11g improve with reliablity and
monitoring tools ?

Not sure what you are asking in that question. The monitoring tools
do keep changing.

  each word will be highly appreciated !

Joe

You probably need to start with a testing plan and have some way of
carefully checking out the direction you are thinking about going in.
HPUX was at one time a favorite platform for oracle as was sun
( solaris ) but the direction has tipped noticeably in favor of linux.

It is going to take a management commitment to come up with resources
to test this kind of upgrade adequately.

Are you still planning on running on HPUX?

.

Relevant Pages

  • Re: Regarding Oracle version upgrading questions
    ...   we are considering seriously on upgrading our database server. ...   To system running records, ... If you are able to locate a copy of "Cost-Based Oracle Fundamentals", ...
    (comp.databases.oracle.server)
  • Re: Regarding Oracle version upgrading questions
    ...   we are considering seriously on upgrading our database server. ... is always sequent read and latch waiting in system. ... and Oracle 10g has been better performance, ...
    (comp.databases.oracle.server)
  • Re: tool: convert classic oracle sql to ansi?
    ... Does anybody know of a way, tool or whatever to convert classic oracle ... as outer joins) into the ANSI equivalent? ...    , ... Thanks for the lambasting of my SQL skills Daniel. ...
    (comp.databases.oracle.server)
  • Re: Oracle Stats
    ...   At any rate, ... search for awr report on oracldoug.com/serendipity. ... but the defaults on the newer Oracle versions are often more ... understanding the kinds of stats and what they mean is something I ...
    (comp.databases.oracle.server)
  • Re: Surprising Performance Changes with Oracle 11.2.0.1 (Long Post)
    ... I am working on an Oracle performance related project, ...     How much memory in the machine? ... O enabled during the full tablescan operation: ... ALTER SYSTEM FLUSH BUFFER_CACHE; ...
    (comp.databases.oracle.server)