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

On Sat, 17 Mar 2001 23:33:53 +0800, "Eddy" <eddyng_at_netvigator.com> wrote:

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

Interesting. I wonder if there is any difference in block sizes being sent on HP. If you use TNSNAMES also in your NT server, does the listener.ora and the tnsnames.ora look the same in both systems? Ie, are there any additional parameters on NT that aren't in HP?

Definitely something wrong with the online side. If performance OK in batch, that means the database is OK. Gotta be something in the net.

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 - 10:52:37 CST