I'm doing a large insert (about 50 million rows) into a table . The system seems to hang. I cant see it doing anything. I checked v$session_wait ? Rollback segments seems to be adequate enough.
Could you tell me what is happening ? and how do I rectify this.
Thanks a lot