Oracle records exactly on
what the waiting time was spent).
There are few options for tuning the imp speed, set recordlength=65535 and
buffer=1048576 for example in imp command line.
The above options don't help (they probably wont help much) then look into
expdp/impdp...
--
Regards,
Tanel Po
/06/oracle-session-snapper-v106-released/
You should run it with let say 1-minute interval on the individual loading
session or all sessions in db. You can post the result so I (or other Oracle
people here) can advise...
--
Regards,
Tanel Poder
http://blog.tanelpoder.com
http://n.otepad.com -
So what's the problem you're trying to solve?
If you simulate any database operation with OS utilities like dd you have to be
sure you're simulating it the same way as database does.
For example, Oracle opens its filesystem datafiles always with O_SYNC option
and with O_DIRECT dependent on whe