Quirky performance differences/problems between connections made by Unix client versus Windows Client

Home -> Community -> Usenet -> c.d.o.server -> Quirky performance differences/problems between connections made by Unix client versus Windows Client

From: Mark PAtterson <m_patte_at_yahoo.com>
Date: 11 Jan 2002 03:05:21 -0800
Message-ID: <4c08015.0201110305.1af52498@posting.google.com>

Hi,

I'm running Oracle 8.1.6 and 8.1.7 databases on a Solaris 8 server and am experiencing quirky performance differences between Solaris based clients and Windows based clients.

In a nutshell clients running on Solaris (including sqlplus running on the database server) seem to freeze up every now and again when attempting to connect or process a select statement etc. I don't even need to be doing data modifications (hence no redo info or locking problems).

However, Windows based clients never experience same symptoms and I've even found that executing a simple select statement via the Windows client (SQL*Plus) actually free up the frozen Solaris client. This "cure" can be applied and works consistently!

Any ideas out there please?

Additional Info: Using MTS for both Windows and Solaris based clients.

Thanks,
Mark. Received on Fri Jan 11 2002 - 05:05:21 CST