The procedure inserted records into a table and committed after every one. So even if it rolled back it would have been for only one record. Everytime I do a alter session kill it says that it is marked for kill but it isn't killed.