Hello all,

I got a deadlock while testing a procedure to update a table on our data warehouse. This was a long updating batch file. Yesterday I ran this procedure and it was too slow and I killed the process using instance manager without checking the status on it, today, I ran it again and killed it using instance manager. Then, I tried to kill the sessions from SQL*PLUS using 'alter system kill session 'sid, serial#';' I got a message 'ORA-000031: the process was marked to kill'. Now, we are shutting down the database with 'shutdown immediate' command from server manager, hoping to solve the problem. My question is: how could we do to get rid of the deadlock? Shutting it down is an option? Your advice would be highly appreciated. Thanks in advance.

Li