Re: Import on 8.1.6 hanging?

Check couple of things

1. If there is any active rollback segment

2, Check the 'command' field of the
  sid from v$session for the sid
  which corresponds to the import process.

  If the numbers are changing ( 1,2 etc.),   you know insert is going on.

  If the number is 0 for a long time,
 probably nothing is happening.

Regards
Willy Received on Sat Feb 10 2001 - 23:06:41 CST