Oracle如何查询被锁定的表及解锁方法
select * from v$locked_object
select object_name, object_type from dba_objects where object_id =‘121057’
select sid, serial#, machine, program from v$session where sid=‘385’
alter system kill session ‘385,53407’
Oracle如何查询被锁定的表及解锁方法
select * from v$locked_object
select object_name, object_type from dba_objects where object_id =‘121057’
select sid, serial#, machine, program from v$session where sid=‘385’
alter system kill session ‘385,53407’