Oracle 00054资源正忙

Oracle 00054 资源正忙

• 查询被锁对象的session_id
  select session_id from v$locked_object;
• 根据session_id 获取 vKaTeX parse error: Expected 'EOF', got '#' at position 19: …sion的sid和serial#̲ select sid,ser…session where sid=122
• 终止相关进程。alter system kill session ‘sid,serial’;
  alter system kill session ‘122,61330’;

select session_id from v$locked_object;
参考：https://www.cnblogs.com/jacktang/p/3442735.html