Re: How to remove Lock on a Table

Interesting. Next time you need to kill a session, how about using ORAKILL to kill the thread. and see if you get better results.

The process ID column in v$process is the thread# on Win2k.

Jared

On Tuesday 18 June 2002 00:18, Alexandre Gorbatchev wrote:
> Hi,
> Looks the same for 9.0.1.3 on w2k. Sometimes I have to bounce db to clean
> up a killed session. :(
>
> --
> Alexandre
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Monday, June 17, 2002 8:39 PM
>
> > Even better. Kill the OS process first, then kill the Session if still
> > necessary.
> >
> > Using 'Alter system kill session' to remove a session holding a lock has
> > always been problematic in Oracle.
> >
> > On occasion, PMON will *not* clean up the session, and a bounce of the
> > database is required to remove the lock.
> >
> > I've seen it happen on 3 OS's, and versions 7.0.16, 7.2, 7.3, 8.04. Not
> > sure
> > about 8i.
> >
> > Jared
> >
> >
> >
> >
> >
> >
> > "David Marshall" <damarsha_at_cisco.com>
> > Sent by: root_at_fatcity.com
> > 06/17/2002 09:23 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
>
> <ORACLE-L_at_fatcity.com>
>
> > cc:
> > Subject: RE: How to remove Lock on a Table
> >
> >
> > You might also want to get the os pid from v$process before issuing the
> > alter system kill session statement.
> > Then you can easily track the os process if needed.
> >
> > Select p.spid
> >
> > >From v$session s, v$process p
> >
> > Where s.paddr = p.addr
> > And s.sid = &sid;
> >
> > -----Original Message-----
> > Sent: 17 June 2002 13:18
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Yeah that will do. But you need to wait as Oracle will Rollback the
> > changed
> > data and then rel the lock.
> >
> > HTH
> >
> > Best Regards,
> > Ganesh R
> > Tel : +971 (4) 397 3337 Ext 420
> > Fax : +971 (4) 397 6262
> > HP : +971 (50) 745 6019
> > ============================================
> > Live to learn... forget... and learn again.
> > ============================================
> >
> >
> >
> > -----Original Message-----
> > Sent: Monday, June 17, 2002 2:13 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hello all,
> >
> > I want to remove lock on a Table by using this
> > command:
> >
> > Alter system kill session '&sid,&serial'
> >
> > Is this enough or I have to do something else!
> >
> > Regards
> >
> > Ashraf Salaymeh
> > System Analyst
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > LAUNCH - Your Yahoo! Music Experience
> > http://launch.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: ASHRAF SALAYMEH
> > INET: ashraf_salaymeh_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Ganesh Raja
> > INET: ganesh_at_gtfs-gulf.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: David Marshall
> > INET: damarsha_at_cisco.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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).
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: Jared.Still_at_radisys.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).