{"id":5131,"date":"2025-05-14T23:40:17","date_gmt":"2025-05-14T15:40:17","guid":{"rendered":"https:\/\/qaqaq.top\/?p=5131"},"modified":"2025-05-14T23:40:17","modified_gmt":"2025-05-14T15:40:17","slug":"%e5%a6%82%e4%bd%95%e6%a3%80%e6%b5%8b%e8%a2%ab%e9%94%81%e4%bd%8f%e7%9a%84oracle%e5%ad%98%e5%82%a8%e8%bf%87%e7%a8%8b","status":"publish","type":"post","link":"https:\/\/qaqaq.top\/?p=5131","title":{"rendered":"\u5982\u4f55\u68c0\u6d4b\u88ab\u9501\u4f4f\u7684Oracle\u5b58\u50a8\u8fc7\u7a0b"},"content":{"rendered":"\n<p>1\u3001\u67e5\u770b\u662f\u54ea\u4e00\u4e2a\u5b58\u50a8\u8fc7\u7a0b\u88ab\u9501\uff0c\u67e5V$DB_OBJECT_CACHE\u89c6\u56fe<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\u67e5V$DB_OBJECT_CACHE\u89c6\u56fe\nselect * from V$DB_OBJECT_CACHE where owner='\u8fc7\u7a0b\u7684\u6240\u5c5e\u7528\u6237' AND LOCKS!='0'<\/code><\/pre>\n\n\n\n<p>2\u3001\u67e5\u770b\u662f\u54ea\u4e00\u4e2asid\uff0c\u901a\u8fc7sid\u53ef\u4ee5\u77e5\u9053\u662f\u54ea\u4e00\u4e2asession\uff0c\u67e5v$access\u89c6\u56fe<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\u67e5v$access\u89c6\u56fe\nselect * from v$access where owner='\u8fc7\u7a0b\u7684\u6240\u5c5e\u7528\u6237' and name='\u521a\u624d\u67e5\u5230\u7684\u8fc7\u7a0b\u540d'<\/code><\/pre>\n\n\n\n<p>3\u3001\u67e5\u51fasid\u548cserial#\uff0c\u67e5v$session\u89c6\u56fe\uff0c\u67e5v$process\u89c6\u56fe<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\u67e5v$session\u89c6\u56fe\nselect sid,serial#,paddr from v$session where sid='\u521a\u624d\u67e5\u5230\u7684sid';\n\u67e5v$process\u89c6\u56fe\nselect spid from v$process where addr='\u521a\u624d\u67e5\u5230\u7684paddr';<\/code><\/pre>\n\n\n\n<p>4\u3001\u6740\u8fdb\u7a0b\uff0c\u5148\u6740oracle\u8fdb\u7a0b\uff0c\u518d\u6740\u64cd\u4f5c\u7cfb\u7edf\u8fdb\u7a0b<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\u5148\u6740oracle\u8fdb\u7a0b\nalter system kill session '\u67e5\u51fa\u7684sid,\u67e5\u51fa\u7684serial#';\n\n\u518d\u6740\u64cd\u4f5c\u7cfb\u7edf\u8fdb\u7a0b\uff0c\u5982\u679c\u662funix\nkill -9 \u521a\u67e5\u51fa\u7684spid\n\u5982\u679c\u662fwindows\norakill \u521a\u67e5\u51fa\u7684sid \u521a\u67e5\u51fa\u7684spid<\/code><\/pre>\n\n\n\n<p>\u53c2\u8003<\/p>\n\n\n\n<p><a href=\"https:\/\/blog.csdn.net\/yulei_qq\/article\/details\/9856835?fromshare=blogdetail&amp;sharetype=blogdetail&amp;sharerId=9856835&amp;sharerefer=PC&amp;sharesource=&amp;sharefrom=from_link\">\u5982\u4f55\u68c0\u6d4b\u88ab\u9501\u4f4f\u7684Oracle\u5b58\u50a8\u8fc7\u7a0b_oracle\u67e5\u8be2\u88ab\u9501\u4f4f\u7684\u5b58\u50a8\u8fc7\u7a0b-CSDN\u535a\u5ba2<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1\u3001\u67e5\u770b\u662f\u54ea\u4e00\u4e2a\u5b58\u50a8\u8fc7\u7a0b\u88ab\u9501\uff0c\u67e5V$DB_OBJECT_CACHE\u89c6\u56fe 2\u3001\u67e5\u770b\u662f\u54ea\u4e00\u4e2asid\uff0c\u901a\u8fc7sid\u53ef\u4ee5 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[199],"tags":[196],"class_list":["post-5131","post","type-post","status-publish","format-standard","hentry","category-oracle-","tag-oracle"],"_links":{"self":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/5131"}],"collection":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5131"}],"version-history":[{"count":1,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/5131\/revisions"}],"predecessor-version":[{"id":5132,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/5131\/revisions\/5132"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}