{"id":2837,"date":"2017-10-27T15:29:56","date_gmt":"2017-10-27T07:29:56","guid":{"rendered":"https:\/\/www.yclimw.com\/?p=2837"},"modified":"2021-05-31T14:08:40","modified_gmt":"2021-05-31T06:08:40","slug":"%e3%80%90ora-02049%e3%80%91%e8%b6%85%e6%97%b6%e5%88%86%e5%b8%83%e5%bc%8f%e4%ba%8b%e5%8a%a1%e5%a4%84%e7%90%86%e7%ad%89%e5%be%85%e9%94%81-%e8%a7%a3%e5%86%b3%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.yclimw.com\/?p=2837","title":{"rendered":"\u3010ORA-02049\u3011\u8d85\u65f6\u5206\u5e03\u5f0f\u4e8b\u52a1\u5904\u7406\u7b49\u5f85\u9501\u00a0\u89e3\u51b3\u65b9\u6cd5"},"content":{"rendered":"

1\u3001\u4ee5sys\u7528\u6237\u767b\u5f55\u6570\u636e\u5e93\u67e5\u8be2\u6b7b\u9501<\/p>\n

SELECT\r\n\tUSERNAME,\r\n\tLOCKWAIT,\r\n\tSTATUS,\r\n\tMACHINE,\r\n\tPROGRAM\r\nFROM\r\n\tV$SESSION\r\nWHERE\r\n\tSID IN (\r\n\t\tSELECT\r\n\t\t\tSESSION_ID\r\n\t\tFROM\r\n\t\t\tV$LOCKED_OBJECT\r\n\t);<\/pre>\n
2\u3001\u4f7f\u7528\u4ee5\u4e0b\u8bed\u53e5\u67e5\u8be2\u88ab\u6b7b\u9501\u7684\u8bed\u53e5<\/p>\n
SELECT\r\n\tSQL_TEXT\r\nFROM\r\n\tV$SQL\r\nWHERE\r\n\tHASH_VALUE IN (\r\n\t\tSELECT\r\n\t\t\tSQL_HASH_VALUE\r\n\t\tFROM\r\n\t\t\tV$SESSION\r\n\t\tWHERE\r\n\t\t\tSID IN (\r\n\t\t\t\tSELECT\r\n\t\t\t\t\tSESSION_ID\r\n\t\t\t\tFROM\r\n\t\t\t\t\tV$LOCKED_OBJECT\r\n\t\t\t)\r\n\t);<\/pre>\n
3\u3001\u4f7f\u7528\u4ee5\u4e0b\u8bed\u53e5\u67e5\u627e\u88ab\u6b7b\u9501\u7684\u8fdb\u7a0b<\/p>\n
SELECT\r\n\tS.USERNAME,\r\n\tL.OBJECT_ID,\r\n\tL.SESSION_ID,\r\n\tS.SERIAL#,\r\n\tL.ORACLE_USERNAME,\r\n\tL.OS_USER_NAME,\r\n\tL. PROCESS\r\nFROM\r\n\tV$LOCKED_OBJECT L,\r\n\tV$SESSION S\r\nWHERE\r\n\tL.SESSION_ID = S. SID;<\/pre>\n
4\u3001\u4f7f\u7528\u4ee5\u4e0b\u8bed\u53e5kill\u6b7b\u9501\u7684\u8fdb\u7a0b<\/p>\n
ALTER SYSTEM KILL SESSION 'sid,serial#';\r\n--\uff08\u5176\u4e2dsid=l.session_id\uff09\r\n--\u5982\uff1aSQL> alter system kill session '24,37522'<\/pre>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
1\u3001\u4ee5sys\u7528\u6237\u767b\u5f55\u6570\u636e\u5e93\u67e5\u8be2\u6b7b\u9501 SELECT USERNAME, LOCKWAIT, STATUS, MA … \u7ee7\u7eed\u9605\u8bfb\u3010ORA-02049\u3011\u8d85\u65f6\u5206\u5e03\u5f0f\u4e8b\u52a1\u5904\u7406\u7b49\u5f85\u9501\u00a0\u89e3\u51b3\u65b9\u6cd5<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"aside","meta":{"footnotes":""},"categories":[98],"tags":[340,339,341],"class_list":["post-2837","post","type-post","status-publish","format-aside","hentry","category-it","tag-ora-02049","tag-oracle","tag-341","post_format-post-format-aside"],"_links":{"self":[{"href":"https:\/\/www.yclimw.com\/index.php?rest_route=\/wp\/v2\/posts\/2837","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yclimw.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yclimw.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yclimw.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yclimw.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2837"}],"version-history":[{"count":1,"href":"https:\/\/www.yclimw.com\/index.php?rest_route=\/wp\/v2\/posts\/2837\/revisions"}],"predecessor-version":[{"id":2838,"href":"https:\/\/www.yclimw.com\/index.php?rest_route=\/wp\/v2\/posts\/2837\/revisions\/2838"}],"wp:attachment":[{"href":"https:\/\/www.yclimw.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2837"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yclimw.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2837"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yclimw.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2837"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}