Re: Killed status

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: jkstill_at_cybcon.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).