数据库中sql锁住了,如何办
1.首先查询
select l.session_id sid, s.serial#,l.locked_mode, l.oracle_username,s.user#, l.os_user_name,s.machine,s.terminal,
a.sql_text, a.action from v$sqlarea a, v$session s, v$locked_object l where l.session_id = s.sid
and s.prev_sql_addr = a.address order by sid, s.serial#
2.删除死锁的。
ALTER SYSTEM KILL SESSION 'SID,SERIAL#' 杀session