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>
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
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