Hi all,
11.2.0.3
aix 6
We have a long running batch job which insert/delete a big table.
The operator not patient with the long process stupidly killed the batch job by kill -9 at OS level, thinking that it already hanged and decided to rerun the batch.
So when he run again the delete is locked by the previous process.
I tried to kill the previous session, but it say its rolling back;
alter system kill session '377,55519'
*
ERROR at line 1:
ORA-00031: session marked for kill
How do I check if the rolling back is hanging already? or frozen?
I remember what I did before what to restart the database just to speed up the rollback since it was not moving.
The problem is there is a 24x7 app running on this database. I we need clearance to the manage to stop/start both the app and db.
Is there a way to force rollback the transaction? or How do check if the rollback is still running?
Thanks,
pK