Re: SQL*Net message from client waits on local import

The *SQL*Net message from client* events instrument the write()/read() call combination that the Oracle kernel makes, regardless of what protocol adapter you use. You'll still see the events, but the latencies should be smaller if you use bequeath or ipc than if you use a thicker-stack communication protocol like tcp.

Cary Millsap
http://method-r.com
http://carymillsap.blogspot.com

On Fri, Jun 6, 2008 at 8:55 AM, steve montgomerie <stmontgo_at_gmail.com> wrote:

> Some background...
>
> Upgrade db from Windows 2003 Oracle 9208 to OEL Oracle 10.2.0.4 the old
> fashioned way with import/export
>
> Export dump files to new Linux server and go with the import!
>
> export LD_LIBRARY_PATH=/u01/app/oracle/product/10.2.0/db_1/lib;
> export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1;
> export ORACLE_SID=HR89PAR1;
> export ORAHOME=/u01/app/oracle/product/10.2.0/db_1;
> export
> PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin:/u01/app/oracle/product/10.2.0/db_1/bin;
>
> /u01/app/oracle/product/10.2.0/db_1/bin/imp sysadm/<password> full=y
> recordlength=65535 commit=n buffer=999999999
> log=/u01/app/oracle/scripts/logs/hr89uat_imp.log
> file=/u03/oradata/exports/orlhr/orlhr1.dmp,/u03/oradata/exports/orlhr/orlhr2.dmp,/u03/oradata/exports/orlhr/orlhr3.dmp,/u03/oradata/exports/orlhr/orlhr4.dmp,/u03/oradata/exports/orlhr/orlhr5.dmp,/u03/oradata/exports/orlhr/orlhr6.dmp,/u03/oradata/exports/orlhr/orlhr7.dmp,/u03/oradata/exports/orlhr/orlhr8.dmp,/u03/oradata/exports/orlhr/orlhr9.dmp,/u03/oradata/exports/orlhr/orlhr10.dmp,/u03/oradata/exports/orlhr/orlhr11.dmp
>
> What I see from tkprof is the usual suspects along with SQL*Net message
> from client waits.
>
> Elapsed times include waiting on following events:
> Event waited on Times Max. Wait Total
> Waited
> ---------------------------------------- Waited ----------
> ------------
> log file sync 2899646 0.97
> 2097.17
> SQL*Net message to client 5818723 0.00
> 4.34
> SQL*Net message from client 5818723 1.49
> 3862.41
> db file sequential read 14054600 0.82
> 7958.39
>
> So why am I seeing a SQL*NET wait? There are 8000 + tables and I see lots
> of little waits here and there, nothing really large.
>
> I thought that my import would be connecting in a bequeath type fashion and
> would therefore not expect to see any SQL*NET waits.
>

--
http://www.freelists.org/webpage/oracle-l