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

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 - 08:44:14 CST