you have just listed the lowest of biological life forms !
-----Original Message-----
Sent: Thursday, June 20, 2002 7:53 PM
To: Multiple recipients of list ORACLE-L
I only engage in that particular activity when there's a good chance
it won't involve an attorney and/or judge.
Jared
Rachel Carmichael <wisernet100_at_YAHOO.COM>
Sent by: root_at_fatcity.com
06/20/2002 05:43 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
instead of whack-a-mole it's "whack-a-duhveloper"?
- Jared.Still_at_radisys.com wrote:
> Personally, I always whack 'em first with a great big stick.
>
> May not be everyone's cup of tea I suppose, but then again,
> I *never* have a hung session holding a lock and requiring
> a database bounce.
>
> Jared
>
>
>
>
>
> "Ben" <poelsb_at_post.queensu.ca>
> Sent by: root_at_fatcity.com
> 06/19/2002 01:28 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
>
>
> Hi
>
> Was any consensus reached on the issue of how best to remove the
> offending sessions, or the difference between the SQL disconnect
> session and kill session? Or was it just left that whacking it
> with a kill -9 was the way to go?
>
> Ben
>
> -----Original Message-----
> Sent: June 17, 2002 3:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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!
>
>
>
> --
> 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: Rachel Carmichael
INET: wisernet100_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:
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: Johnson, Michael
INET: Michael.Johnson_at_oln-afmc.af.mil
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).
Received on Fri Jun 21 2002 - 12:07:30 CDT
