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
[EMAIL PROTECTED]              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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to