SQL*Net message from client waits on local import
- From: "steve montgomerie" <stmontgo@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 6 Jun 2008 09:55:35 -0400
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.
Other related posts:
