Performance degrade after migrate db from NT to HP-UX

From: Eddy <eddyng_at_netvigator.com>
Date: Sat, 17 Mar 2001 22:28:40 +0800
Message-ID: <98vs3j$eeh4_at_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 - 15:28:40 CET

Original text of this message