Performance degrade after migrate db from NT to HP-UX

From: Eddy <eddyng_at_netvigator.com>
Date: Sat, 17 Mar 2001 22:27:36 +0800
Message-ID: <98vs1i$e251@imsp212.netvigator.com>

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 Sat Mar 17 2001 - 08:27:36 CST