Re: Killed status

[Arup Nanda]

This means the transaction issued by the session is still rolling back. The session is not killed completely or the table locks removed till the transaction completely rolls back.   So how do you know when it's going to be over? Just issue the following query   SELECT USED_UBLK FROM V$TRANSACTION WHERE ADDR = (SELECT TADDR FROM V$SESSION WHERE SID = yoursid)   The USED_BLK shows number of blocks used by this transaction in the UNDO segments and when this transaction rolls back, the blocks are released. Issue this query repeatedly and you sould see the USED_UBLK figure dropping and that will give you some indication how fast the roll back is taking place.   HTH   Arup Nanda www.proligence.com ----- Original Message ----- From: shuan.tay(PCI鄭祺勛) To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 25, 2002 10:48 PM Subject: Killed status Dear all DBAs,   Is there any way to remove the lock of table which status is already marked as "killed"? No matter how many times i try to kill the session, it still marked as "killed", but it still won't release the lock.   Thanks in advance.