select object_id from dba_objects
where object_name = ‘MYTABLE’;
select sid, id1, id2
from v$lock
where id1= &objid
or id2 = &objid;
select object_id from dba_objects
where object_name = ‘MYTABLE’;
select sid, id1, id2
from v$lock
where id1= &objid
or id2 = &objid;
