Sunday, March 6, 2011

Remove Table Level Lock in Oracle

select * from dba_objects where object_name='PROVISIONING';
/* 180693 */

select * from v$locked_object where object_id=180693

select * from v$access where owner='PROD' and object='PROVISIONING';

select sid, serial#, command, taddr from v$session where sid=88

alter system kill session '88,57147';

commit

No comments: