Oracle-L: Re: Killed status

From: Arup Nanda <arupnanda_at_hotmail.com>
Date: Wed, 25 Dec 2002 22:18:42 -0800
Message-ID: <F001.00522144.20021225221842@fatcity.com>

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¾G¸R³Ô) 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.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Arup Nanda
INET: arupnanda_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Dec 26 2002 - 00:18:42 CST