I'm attempting to determine why one nightwork script slowed
down ( previously ran in 12 minutes now 50+ minutes).
The script run against instance "PROD" & invoke PL/SQL.
The PL/SQL uses database links to access instance "WRK".
I've run with SQL_TRACE enable on both DBs.
PROD shows large values for "SQL*Net message from dblink";
which I can accept & understand.
WRK shows large values for "SQL*Net more data from client";
which I totally do NOT understand.
AFAIK, the PL/SQL code which runs on WRK only access data
with the WRK instance.
I don't really understand who/what the "client" is in this
context.
What do I now need to do to determine how to reduce the
"SQL*Net more data from client" wait time?
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at
http://www.freelists.org/archives/oracle-l/
FAQ is at
http://www.freelists.org/help/fom-serve/cache/1.html
Received on Fri Jul 02 2004 - 09:01:36 CDT
