select * from v$lock a ,all_objects b
where ctime > 1222 and type='TM'
and a.id1=b.object_id and b.object_name = ''
###b.object_name对应要查询的表
转载于:https://my.oschina.net/u/2308739/blog/649027
select * from v$lock a ,all_objects b
where ctime > 1222 and type='TM'
and a.id1=b.object_id and b.object_name = ''
###b.object_name对应要查询的表
转载于:https://my.oschina.net/u/2308739/blog/649027