Re: Performance degrade after migrate db from NT to HP-UX
Date: Sat, 17 Mar 2001 16:12:33 GMT
Message-ID: <R1Ms6.582638$U46.17412697_at_news1.sttls1.wa.home.com>
Try analyzing the tables.
"Eddy" <eddyng_at_netvigator.com> wrote in message
news:98vs3j$eeh4_at_imsp212.netvigator.com...
analyze table TABLE_NAME compute statistics;
> 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:12:33 CET