| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Unlocking a table.
If you are on UNIX, you may be able to kill the OS process:
select a.spid (which is the OS process id)
from v$process a, v$session b
where b.paddr = a.addr
and b.sid = <the sid>
and b.serial# = <the serial#>;
Then kill -9 the process id.
Tom
-----Original Message-----
From: Anindya, Roy (GEAE, Foreign National)
[mailto:Roy.Anindya_at_ae.ge.com]
Sent: Friday, January 12, 2001 3:53 PM
To: Multiple recipients of list ORACLE-L
Subject: Unlocking a table.
Hi Gurus,
Is there any other way of unlocking an oracle table apart from
"Alter system Kill session....."
I have tried the above command and got back the message saying that the session has been killed,but V$Lock and V$Locked_Object still shows the same Sid locking a particular table.Now the Alter system command gives a response as "session does not exist"
Any ideas?? can't shut down the database now,but need to free this table for insert and updates. The lock mode is 3 (row)
thanks in advance,
Anindya.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anindya, Roy (GEAE, Foreign National) INET: Roy.Anindya_at_ae.ge.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-LReceived on Fri Jan 12 2001 - 15:21:21 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |