锁表问题的处理
查询目前锁对象信息
col sid for 999999
col username for a10
col schemaname for a10
col osuser for a16
col machine for a16
col terminal for a20
col owner for a10
col object_name for a30
col object_type for a10
SELECT l.session_id sid, s.serial#, l.locked_mode,l.oracle_username,
l.os_user_name,s.machine, s.terminal, o.object_name, s.logon_time
FROM v$locked_object l, all_objects o, v$session s
WHERE l.object_id = o.object_id
AND l.session_id = s.sid
ORDER BY sid, s.serial# ;
根据sql_id找到sql_text
select * from gv$sql where sql_id='&sql_id';
解锁处理
ALTER SYSTEM KILL SESSION '&sid,&serial#';
锁表:
LOCK TABLE tablename IN EXCLUSIVE MODE
(笔者原创文章,转载请注明出处:https://blog.csdn.net/LFCuiYs)谢谢!