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

On Sat, 17 Mar 2001 22:27:36 +0800, "Eddy" <eddyng_at_netvigator.com> wrote:

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

If online is slower and batch faster, I'd look first at the setup for network and how it is being accessed. Do you have dedicated sessions or are you using MTS? That could make a difference. Is the slowness when the on-line program starts or is it all the way through while it is running? Are you using Names or not?

Whatever, I think you need to look at the Net8 setup.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Sat Mar 17 2001 - 09:15:33 CST