How to Unlock the Objects
The following query could be useful :
Select SPID from V$PROCESS where ADDR in
(select PADDR from V$SESSION where SID in
(select SESSION_ID from V$LOCKED_OBJECT where OBJECT_ID in
(select OBJECT_ID from DBA_OBJECTS where OBJECT_NAME=’Locked Object’)))
Get the Process id from the query. Login as unix user and run the following command to kill the process.
$kill -9 SPID
Tuesday, November 11, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment