If you are running MTS, might it be something to
do with adjusting the numbers of shared servers
for different protocols ?
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Now running 3-day intensive seminars
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Mark PAtterson wrote in message
<4c08015.0201110305.1af52498_at_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 - 08:03:25 CST
