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

Hi Eddy,

we had a similar effect that an NT client worked fast and the local Unix client was slow, both connecting to the same instance on Unix.

Solution was to restart the Unix listener with protocol.ora containing the line "tcp.nodelay = yes".

Martin

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.
>
> Thanks for your kindly help,
>
> Eddy
Received on Fri Mar 23 2001 - 18:31:12 CST