Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to remove Lock on a Table
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
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).
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).
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). Received on Mon Jun 17 2002 - 13:39:22 CDT
![]() |
![]() |