oracle数据库查询锁并解锁

–查锁表
SELECT p.spid, a.serial#, c.object_name, b.session_id, b.oracle_username,b.os_user_name
FROM v$processp,v$session a, vKaTeX parse error: Expected 'EOF', got '#' at position 166: … b.sid,b.serial#̲ from vlocked_object a,v$session b
where a.session_id = b.sid group by b.sid,b.serial#;

begin
for cur in mycur
loop
execute immediate ( ‘alter system kill session ‘’’||cur.sid || ‘,’|| cur.SERIAL# ||‘’’ ');
end loop;
end;

注：批量解锁的时候可能会报错，多执行两次就行了。