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

We're using dedicated server with TNSNAMES only on HP-UX now. Both NT & HP-UX on the same subnet and we're in client-server model by using PowerBuilder, therefore, the startup time is the same, only when retriving online data from db has different....

Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam> wrote in message news:3ab37e34.22081765_at_news-server...
> 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:33:53 CST