RE: How to remove Lock on a Table

One can be subtle about it an tell that to the session by using very subtle and unnoticable "kill -9" command. JDBC normally connects as a dedicated server session. There are v$session and v$process, find SPID and execute it with extreme prejudice (kill -9). Make sure you're not killing SMON, PMON or LGWR.

> -----Original Message-----
> From: Jack Silvey [mailto:jack_silvey_at_yahoo.com]
> Sent: Monday, June 17, 2002 3:09 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: How to remove Lock on a Table
>
>
> interesting point - anyone know how the 8i "alter
> system disconnect session immediate" differentates
> from the "alter system kill session"? read something
> somewhere about it destroying the virtual circuit. I
> always suspected that it ignored the wait period that
> the "kill" command goes through to tell the client it
> is dead (which of course it can't with connection
> forms like JDBC, so the session never dies).
>
> Jack
>
>
> --- Jared.Still_at_radisys.com wrote:
> > 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).
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jack Silvey
> INET: jack_silvey_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: Gogala, Mladen
  INET: MGogala_at_oxhp.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).