{"id":377,"date":"2019-07-25T13:55:24","date_gmt":"2019-07-25T05:55:24","guid":{"rendered":"http:\/\/www.inhhh.com\/blog\/?p=377"},"modified":"2019-07-25T13:55:24","modified_gmt":"2019-07-25T05:55:24","slug":"oracle-11-2-0-1%e7%9a%84%e4%b8%80%e4%b8%aabug%ef%bc%8c%e5%ae%a2%e6%88%b7%e7%ab%af%e6%8a%a5ora-03113-%e9%80%9a%e4%bf%a1%e9%80%9a%e9%81%93%e7%9a%84%e6%96%87%e4%bb%b6%e7%bb%93%e5%b0%be","status":"publish","type":"post","link":"http:\/\/www.inhhh.com\/blog\/?p=377","title":{"rendered":"Oracle 11.2.0.1\u7684\u4e00\u4e2aBug\uff0c\u5ba2\u6237\u7aef\u62a5ORA-03113: \u901a\u4fe1\u901a\u9053\u7684\u6587\u4ef6\u7ed3\u5c3e"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"> <br><a href=\"https:\/\/www.cnblogs.com\/zhaoguan_wang\/p\/6142481.html\">Oracle 11.2.0.1\u7684\u4e00\u4e2aBug\uff0c\u5ba2\u6237\u7aef\u62a5ORA-03113: \u901a\u4fe1\u901a\u9053\u7684\u6587\u4ef6\u7ed3\u5c3e<\/a> <br><\/h2>\n\n\n\n<p>Posted on&nbsp;2016-12-07 19:52&nbsp;<a href=\"https:\/\/www.cnblogs.com\/zhaoguan_wang\/\">\u53ec\u51a0<\/a>&nbsp;\u9605\u8bfb(3753) \u8bc4\u8bba(0)&nbsp;<a href=\"https:\/\/i.cnblogs.com\/EditPosts.aspx?postid=6142481\">\u7f16\u8f91<\/a><a href=\"https:\/\/www.cnblogs.com\/zhaoguan_wang\/p\/6142481.html#\">\u6536\u85cf<\/a><\/p>\n\n\n\n<p>\u534a\u5c0f\u65f6\u524d\uff0c\u4e00\u4e2a\u9879\u76ee\u53cd\u9988\u5e94\u7528\u7cfb\u7edf\u90e8\u5206\u529f\u80fd\u62a5\u9519\uff0cORA-03113: \u901a\u4fe1\u901a\u9053\u7684\u6587\u4ef6\u7ed3\u5c3e\u3002\u597d\u50cf\u662f\u4e2a\u5e38\u89c1\u7684\u9519\u8bef\u3002(jdbc\u7a0b\u5e8f\u62a5\u51fa\u7684\u9519\u8bef\u662f\uff1a\u65e0\u6cd5\u4ece\u5957\u63a5\u5b57\u8bfb\u53d6\u66f4\u591a\u7684\u6570\u636e)<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">\u5f02\u5e38\u4fe1\u606f:ORA-03113: \u901a\u4fe1\u901a\u9053\u7684\u6587\u4ef6\u7ed3\u5c3e\n\u8fdb\u7a0b ID: 2392\n\u4f1a\u8bdd ID: 298 \u5e8f\u5217\u53f7: 46826<\/pre>\n\n\n\n<p>\u68c0\u67e5\u4e86\u5f52\u6863\u65e5\u5fd7\u672a\u53d1\u73b0\u5f02\u5e38\uff0c\u68c0\u67e5Oracle\u65e5\u5fd7\u65f6\u53d1\u73b0\u5bf9\u5e94ORA-03137\u9519\u8bef\uff0c\u7ecf\u67e5\u9605\u7f51\u4e0a\u8d44\u6599\uff0c\u5c5e\u4e8eOracle\u7684bug\uff0cGod\uff0c\u7adf\u7136\u9690\u853d\u5728ORA-03113\u540e\u9762\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"javascript:void(0);\"><img decoding=\"async\" src=\"https:\/\/common.cnblogs.com\/images\/copycode.gif\" alt=\"\u590d\u5236\u4ee3\u7801\"\/><\/a><\/figure>\n\n\n\n<pre class=\"wp-block-preformatted\">Errors in file d:\\app\\administrator\\diag\\rdbms\\fssc\\fssc\\trace\\fssc_ora_3972.trc  (incident=137360):\nORA-03137: TTC \u534f\u8bae\u5185\u90e8\u9519\u8bef: <strong>[<\/strong>12333<strong>]<\/strong> <strong>[<\/strong>36<strong>]<\/strong> <strong>[<\/strong>53<strong>]<\/strong> <strong>[<\/strong>56<strong>]<\/strong> <strong>[]<\/strong> <strong>[]<\/strong> <strong>[]<\/strong> <strong>[]<\/strong>\nWed Dec 07 19:09:00 2016\nSweep <strong>[<\/strong>inc<strong>][<\/strong>137360<strong>]<\/strong>: completed\nWed Dec 07 19:12:06 2016\nErrors in file d:\\app\\administrator\\diag\\rdbms\\fssc\\fssc\\trace\\fssc_ora_3468.trc  (incident=137596):\n<strong>ORA-<\/strong><strong>03137: TTC \u534f\u8bae\u5185\u90e8\u9519\u8bef<\/strong>: <strong>[<\/strong>12333<strong>]<\/strong> <strong>[<\/strong>36<strong>]<\/strong> <strong>[<\/strong>48<strong>]<\/strong> <strong>[<\/strong>98<strong>]<\/strong> <strong>[]<\/strong> <strong>[]<\/strong> <strong>[]<\/strong> <strong>[]<\/strong>\nWed Dec 07 19:12:07 2016\nSweep <strong>[<\/strong>inc<strong>][<\/strong>137596<strong>]<\/strong>: completed<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"javascript:void(0);\"><img decoding=\"async\" src=\"https:\/\/common.cnblogs.com\/images\/copycode.gif\" alt=\"\u590d\u5236\u4ee3\u7801\"\/><\/a><\/figure>\n\n\n\n<p>\u89e3\u51b3\u65b9\u6cd5\uff1a<\/p>\n\n\n\n<p>1\u3001\u5347\u7ea7Oracle\u523011.2.0.3\/4<\/p>\n\n\n\n<p>2\u3001\u589e\u52a0hint\u63d0\u793a\uff1a&nbsp;\/*+opt_param(&#8216;_optim_peek_user_binds&#8217;, &#8216;false&#8217;)*\/<\/p>\n\n\n\n<p>3\u3001\u5173\u95ed\u9690\u85cf\u53c2\u6570\uff1a\u7ed1\u5b9a\u53d8\u91cf\u7684\u7aa5\u89c6<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SQL&gt; alter system set \"_optim_peek_user_binds\" = false;<\/pre>\n\n\n\n<p>\u8bbe\u7f6e\u9690\u85cf\u53c2\u6570\u540e\uff0c\u95ee\u9898\u6d88\u5931\u3002\u5efa\u8bae\u540e\u671f\u66f4\u65b0Oracle\u8865\u4e01\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle 11.2.0.1\u7684\u4e00\u4e2aBug\uff0c\u5ba2\u6237\u7aef\u62a5ORA-03113: \u901a\u4fe1\u901a\u9053\u7684\u6587\u4ef6\u7ed3\u5c3e Posted o<\/p>\n<div class=\"more-link\">\n\t\t\t\t <a href=\"http:\/\/www.inhhh.com\/blog\/?p=377\" class=\"link-btn theme-btn\"><span>Read More <\/span> <i class=\"fa fa-caret-right\"><\/i><\/a>\n\t\t\t<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-377","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/377","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=377"}],"version-history":[{"count":1,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/377\/revisions"}],"predecessor-version":[{"id":378,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/377\/revisions\/378"}],"wp:attachment":[{"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=377"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.inhhh.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}