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

all db objects have analyzed before the test start.... and the db layout is exactly the same as on NT...

Jim Kennedy <kennedy-family_at_home.com> wrote in message news:R1Ms6.582638$U46.17412697_at_news1.sttls1.wa.home.com...
> Try analyzing the tables.
> analyze table TABLE_NAME compute statistics;
>
> "Eddy" <eddyng_at_netvigator.com> wrote in message
> news: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 - 17:25:22 CET