Oracle-L: RE: Wait event problems

From: Seefelt, Beth <Beth.Seefelt_at_TetleyUSA.com>
Date: Thu, 13 Jun 2002 16:28:21 -0800
Message-ID: <F001.0047D892.20020613162821@fatcity.com>

Hi Rich,

I'm curious, what value did you decide on for SDU? Let us know how it works out.

Thanks,

Beth

-----Original Message-----
Sent: Thursday, June 13, 2002 1:39 PM
To: Multiple recipients of list ORACLE-L

Hi Lee,

I'm investigating a very similar problem on 8.1.6.0.0 on Solaris. So far,
I've found out that the 3rd-party vendor who setup this debacle had inserted
invalid values for SDU/TDU in tnsnames.ora on the client and listener.ora on
the server. I'm correcting them now as we speak. (Incidentally, Oracle recommends NOT modifying TDU and gives no guidelines as to how to select a
value.)

Also, our clients are Java apps, which would be my guess as to the root of
the problem. The clients just aren't fast enough to deal with the rather
large overhead of Java. But I'm cautiously optimistic on the SDU/TDU fix...

And www.fatcity.com doesn't want to respond, so we'll have to wait a bit to
search the archives.

GL!

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI

USA -----Original Message-----
Sent: Thursday, June 13, 2002 10:23 AM
To: Multiple recipients of list ORACLE-L

All,

Oracle 8.0.5.0.0
Tru64 v4.0f

We are running a job and statspack reports show that our only problem (it is
running like a dog) is the following

SQL*Net more data from client.

Done some reading and still none the wiser. Anyone else had this sort of problem and if so how did you get around it ??

Regards

Lee
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Jesse, Rich
INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Seefelt, Beth
INET: Beth.Seefelt_at_TetleyUSA.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------