Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

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

From: Stefan <sroesch3_at_attbi.com>
Date: Sun, 13 Jan 2002 03:57:20 GMT
Message-ID: <AA708.16355$Vq.110336@rwcrnsc53>


Hi Mark,

check for what you are really waiting.
Set event 10046 level 8 in that session and look in the created trace file for the wait event.

It may also be worth to turn off MTS to see if the problem reproduces.

Stefan

Mark PAtterson wrote:

> 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 Sat Jan 12 2002 - 21:57:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US