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" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/19/2002 01:28 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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
--- [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 06/17/2002 09:23 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
