How do you know that, it is not doing anything. Open another SQL session and count the number of rows in that table. If it is still hanging, may be you need to kill the session. You will be able to see those rows if you are committing for x number of rows.