{"id":393,"date":"2015-03-10T13:41:50","date_gmt":"2015-03-10T05:41:50","guid":{"rendered":"http:\/\/www.llku.com\/?p=393"},"modified":"2016-04-20T21:49:02","modified_gmt":"2016-04-20T13:49:02","slug":"%e4%bb%98%e6%ac%be%e4%b8%80%e7%9b%b4%e5%a4%84%e4%ba%8e%e5%b7%b2%e6%94%b6%e9%9b%86%e4%bb%98%e6%ac%be%e8%a7%a3%e5%86%b3%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.llku.com\/?p=393","title":{"rendered":"\u4ed8\u6b3e\u4e00\u76f4\u5904\u4e8e\u5df2\u6536\u96c6\u4ed8\u6b3e\u89e3\u51b3\u65b9\u6cd5"},"content":{"rendered":"<p>\n\t&nbsp;&nbsp;&nbsp; \u524d\u6bb5\u65f6\u95f4\u505a\u4e00\u7b14\u6279\u91cf\u4ed8\u6b3e\u65f6\u5019\uff0c\u4e00\u76f4\u5904\u4e8e\u5df2\u6536\u96c6\u4ed8\u6b3e\u72b6\u6001\uff0c\u4ece\u9501\u8868\u3001\u53d6\u6d88\u7684\u89d2\u5ea6\u53bb\u770b\uff0c\u90fd\u6b63\u5e38\u3002<br \/>\n\t\u4e8e\u662f\u6309\u7167\u56fe\u7247\u7684\u987a\u5e8f\u64cd\u4f5c\uff0c\u89e3\u51b3\u3002\n<\/p>\n<p>\n\t&#8211;\u9501\u8868\n<\/p>\n<p>\n\tselect dob.object_name table_name,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lo.locked_mode,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; lo.session_id,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; vss.serial#,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; vps.spid,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; vss.action action,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; vss.osuser osuser,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; vss.process ap_pid,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; vps.spid db_pid,<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &#39;alter system kill session &#39; || &#39;&#39;&#39;&#39; || lo.session_id || &#39;,&#39; ||<br \/>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; vss.serial# || &#39;&#39;&#39;;&#39; kill_command<br \/>\n\t&nbsp; from v$locked_object lo, dba_objects dob, v$session vss, v$process vps<br \/>\n\t&nbsp;where lo.object_id = dob.object_id<br \/>\n\t&nbsp;&nbsp; and lo.session_id = vss.sid<br \/>\n\t&nbsp;&nbsp; and vss.paddr = vps.addr<br \/>\n\t&nbsp;order by 2, 3, dob.object_name;\n<\/p>\n<p>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href=\"http:\/\/www.llku.com\/?attachment_id=394\" rel=\"attachment wp-att-394\"><img loading=\"lazy\" alt=\"1.\u5df2\u6536\u96c6\u4ed8\u6b3e\" class=\"alignnone size-medium wp-image-394\" height=\"49\" src=\"http:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/1.\u5df2\u6536\u96c6\u4ed8\u6b3e-300x49.jpg\" width=\"300\" srcset=\"https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/1.\u5df2\u6536\u96c6\u4ed8\u6b3e-300x49.jpg 300w, https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/1.\u5df2\u6536\u96c6\u4ed8\u6b3e-1024x167.jpg 1024w, https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/1.\u5df2\u6536\u96c6\u4ed8\u6b3e-900x146.jpg 900w, https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/1.\u5df2\u6536\u96c6\u4ed8\u6b3e.jpg 1193w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\n<\/p>\n<p>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href=\"http:\/\/www.llku.com\/?attachment_id=395\" rel=\"attachment wp-att-395\"><img loading=\"lazy\" alt=\"2.\u8bf7\u6c42\u4e5f\u6b63\u5e38\" class=\"alignnone size-medium wp-image-395\" height=\"116\" src=\"http:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/2.\u8bf7\u6c42\u4e5f\u6b63\u5e38-300x116.jpg\" width=\"300\" srcset=\"https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/2.\u8bf7\u6c42\u4e5f\u6b63\u5e38-300x116.jpg 300w, https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/2.\u8bf7\u6c42\u4e5f\u6b63\u5e38.jpg 836w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\n<\/p>\n<p>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href=\"http:\/\/www.llku.com\/?attachment_id=396\" rel=\"attachment wp-att-396\"><img loading=\"lazy\" alt=\"3.\u7ed3\u679c\u4e00\u76f4\u6ca1\u6709\u53d8\" class=\"alignnone size-medium wp-image-396\" height=\"116\" src=\"http:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/3.\u7ed3\u679c\u4e00\u76f4\u6ca1\u6709\u53d8-300x116.png\" width=\"300\" srcset=\"https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/3.\u7ed3\u679c\u4e00\u76f4\u6ca1\u6709\u53d8-300x116.png 300w, https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/3.\u7ed3\u679c\u4e00\u76f4\u6ca1\u6709\u53d8.png 719w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\n<\/p>\n<p>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href=\"http:\/\/www.llku.com\/?attachment_id=397\" rel=\"attachment wp-att-397\"><img loading=\"lazy\" alt=\"4.\u901a\u8fc7\u6b64\u754c\u9762\u627e\u51fa\u5355\u5b50\" class=\"alignnone size-medium wp-image-397\" height=\"119\" src=\"http:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/4.\u901a\u8fc7\u6b64\u754c\u9762\u627e\u51fa\u5355\u5b50-300x119.png\" width=\"300\" srcset=\"https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/4.\u901a\u8fc7\u6b64\u754c\u9762\u627e\u51fa\u5355\u5b50-300x119.png 300w, https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/4.\u901a\u8fc7\u6b64\u754c\u9762\u627e\u51fa\u5355\u5b50-1024x406.png 1024w, https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/4.\u901a\u8fc7\u6b64\u754c\u9762\u627e\u51fa\u5355\u5b50-900x357.png 900w, https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/4.\u901a\u8fc7\u6b64\u754c\u9762\u627e\u51fa\u5355\u5b50.png 1317w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\n<\/p>\n<p>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href=\"http:\/\/www.llku.com\/?attachment_id=398\" rel=\"attachment wp-att-398\"><img loading=\"lazy\" alt=\"5.\u70b9\u51fb\u505c\u6b62\u4ed8\u6b3e\" class=\"alignnone size-medium wp-image-398\" height=\"55\" src=\"http:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/5.\u70b9\u51fb\u505c\u6b62\u4ed8\u6b3e-300x55.png\" width=\"300\" srcset=\"https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/5.\u70b9\u51fb\u505c\u6b62\u4ed8\u6b3e-300x55.png 300w, https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/5.\u70b9\u51fb\u505c\u6b62\u4ed8\u6b3e-1024x188.png 1024w, https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/5.\u70b9\u51fb\u505c\u6b62\u4ed8\u6b3e-900x165.png 900w, https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/5.\u70b9\u51fb\u505c\u6b62\u4ed8\u6b3e.png 1331w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\n<\/p>\n<p>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href=\"http:\/\/www.llku.com\/?attachment_id=399\" rel=\"attachment wp-att-399\"><img loading=\"lazy\" alt=\"6.\u786e\u8ba4\u505c\u6b62\u4ed8\u6b3e\" class=\"alignnone size-medium wp-image-399\" height=\"94\" src=\"http:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/6.\u786e\u8ba4\u505c\u6b62\u4ed8\u6b3e-300x94.png\" width=\"300\" srcset=\"https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/6.\u786e\u8ba4\u505c\u6b62\u4ed8\u6b3e-300x94.png 300w, https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/6.\u786e\u8ba4\u505c\u6b62\u4ed8\u6b3e-1024x322.png 1024w, https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/6.\u786e\u8ba4\u505c\u6b62\u4ed8\u6b3e-900x283.png 900w, https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/6.\u786e\u8ba4\u505c\u6b62\u4ed8\u6b3e.png 1310w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\n<\/p>\n<p>\n\t&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href=\"http:\/\/www.llku.com\/?attachment_id=400\" rel=\"attachment wp-att-400\"><img loading=\"lazy\" alt=\"7.\u786e\u8ba4\u5220\u9664\" class=\"alignnone size-medium wp-image-400\" height=\"115\" src=\"http:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/7.\u786e\u8ba4\u5220\u9664-300x115.png\" width=\"300\" srcset=\"https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/7.\u786e\u8ba4\u5220\u9664-300x115.png 300w, https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/7.\u786e\u8ba4\u5220\u9664-1024x394.png 1024w, https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/7.\u786e\u8ba4\u5220\u9664-900x346.png 900w, https:\/\/www.llku.com\/wp-content\/uploads\/2015\/03\/7.\u786e\u8ba4\u5220\u9664.png 1341w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp;&nbsp;&nbsp; \u524d\u6bb5\u65f6\u95f4\u505a\u4e00\u7b14\u6279\u91cf\u4ed8\u6b3e\u65f6\u5019\uff0c\u4e00\u76f4\u5904\u4e8e\u5df2\u6536\u96c6\u4ed8\u6b3e\u72b6\u6001\uff0c\u4ece\u9501\u8868\u3001\u53d6\u6d88\u7684\u89d2\u5ea6\u53bb &hellip; <a href=\"https:\/\/www.llku.com\/?p=393\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">\u4ed8\u6b3e\u4e00\u76f4\u5904\u4e8e\u5df2\u6536\u96c6\u4ed8\u6b3e\u89e3\u51b3\u65b9\u6cd5<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[26],"tags":[76],"_links":{"self":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/393"}],"collection":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=393"}],"version-history":[{"count":4,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/393\/revisions"}],"predecessor-version":[{"id":687,"href":"https:\/\/www.llku.com\/index.php?rest_route=\/wp\/v2\/posts\/393\/revisions\/687"}],"wp:attachment":[{"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.llku.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}