SQL*Net message from client waits on local import

From: steve montgomerie <stmontgo_at_gmail.com>
Date: Fri, 6 Jun 2008 09:55:35 -0400
Message-ID: <5d4504220806060655h17b43857vd8f24c2f4cdb7c93@mail.gmail.com>

Some background...

Upgrade db from Windows 2003 Oracle 9208 to OEL Oracle 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

/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 ----------
    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.

Received on Fri Jun 06 2008 - 08:55:35 CDT

Original text of this message