RE: How to remove Lock on a Table

I have all the subtlety and grace of an 18-wheeler.

> -----Original Message-----
> From: Jared.Still_at_radisys.com [mailto:Jared.Still_at_radisys.com]
> Sent: Monday, June 17, 2002 5:34 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: How to remove Lock on a Table
>
>
> Subtlety?
>
> Mladen, have you been attending charm school, or reading
> Miss Manners perhaps?
>
> Jared
>
>
>
>
>
>
> "Gogala, Mladen" <MGogala_at_oxhp.com>
> Sent by: root_at_fatcity.com
> 06/17/2002 02:04 PM
> 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
>
>
> 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).
>
>
>
> --
> 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: 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).