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!
/u01/app/oracle/product/10.2.0/db_1/bin/imp sysadm/ full=y
recordlength=65535 commit=n buffer=999999999
What I see from tkprof is the usual suspects along with SQL*Net message from
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total
log file sync 2899646 0.97
SQL*Net message to client 5818723 0.00
SQL*Net message from client 5818723 1.49
db file sequential read 14054600 0.82
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.