Oracle 死結,oracle死結

來源:互聯網
上載者:User

Oracle 死結,oracle死結

手動修改某表的記錄,彈出以下錯誤:

然後嘗試用PL/SQL語句修改記錄,十多分鐘過去了,一直顯示正在執行;
結論:死結了!!
查看被鎖對象:

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 sWHERE l.object_id = o.object_id   AND l.session_id = s.sidORDER BY sid, s.serial#;



殺掉該鎖對象:模板:alter system kill session 'sid,serial#' immediate;執行個體:alter system kill session '7,223' immediate;

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.