Re: Performance degrade after migrate db from NT to HP-UX

Actually the db layout is exactly the same as on NT. We haven't analyze objects on NT but do analyze objects on HP-UX before testing....

GC <assistant_madman_at_hotmail.com> wrote in message news:3AB3799B.AF8024E8_at_hotmail.com...
> Eddy wrote:
> >
> > Hi all,
> >
> > We've migrate our prod DB from Oracle 8.0.5 on NT to Oracle 8.0.5 on
 HP-UX
> > 11.0. The HP9000 is definitely powerful than our existing NT in terms
 of
> > CPU power & memory. All batch jobs (including reports) run much faster
 than
> > previous (approx. 3~4 times faster), however, the online transaction
> > performance is degraded (e.g. a recordset need 3 seconds to load on NT &
 now
> > need more than 10 seconds).
> >
> > Any ideas? We try to allocate more memory to SGA, enable async-io at OS
> > level, turn off logging for temp tables ...etc. But still have no any
> > improvement.
>
> Where to start? How many spindles do you have? What is the layout of the
> dbfiles? Are the tables analyzed on a regular basis? Has the kernel been
> optimized for Oracle? Has an index or two been forgotten? Do you have
> the init parameter 'run_really_fast = false'? :)
>
> Cheers,
> GC
Received on Sat Mar 17 2001 - 09:29:59 CST