Re: Performance degrade after migrate db from NT to HP-UX
Date: Sat, 17 Mar 2001 17:46:36 GMT
Message-ID: <0qNs6.583008$U46.17432502_at_news1.sttls1.wa.home.com>
If you use SQLPlus how long does it take? What is the execution plan? Can
you compare the execution plans on both boxes to make sure they are the
same? Focus on one query.
Jim
"Eddy" <eddyng_at_netvigator.com> wrote in message
news:9902uc$s111_at_imsp212.netvigator.com...
> 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 - 18:46:36 CET