You don't mention the version of database. It's not completely unheard of for a killed session holding a lock to require a database bounce to release the lock, as there are (unreproducable) cases of PMON never cleaning up a session that was killed while holding a lock.
I've seen it happen a number of times. If the session persists after 24 hours, you most likely need to bounce the database. Jared On Wednesday 25 December 2002 19:48, shuan.tay\(PCI???\) wrote: > 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. ---------------------------------------- Content-Type: text/html; charset="big5"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: ---------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).