OracleApps02
Shivaji Rajaram Umale
Mob No. +91-7875947412
How to UnLock Table Query
(
select a.sid,c.* from v$session a,v$lock b ,all_objects c where a.sid=b.sid and b.id1=object_id and object_name like 'XX%'
);
SID:-333
Serial#:- 222
ALTER SYSTEM KILL SESSION '333,222' ;
Newer Post
Older Post
Home