{"id":1298,"date":"2012-10-25T23:32:26","date_gmt":"2012-10-25T15:32:26","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1298"},"modified":"2013-03-16T21:35:51","modified_gmt":"2013-03-16T13:35:51","slug":"ora-7445_kkqtnlocbk%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1298","title":{"rendered":"ORA-7445(_kkqtnloCbk)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u623710.2.0.1 for Windows 32\u6570\u636e\u5e93\u51fa\u73b0ORA-7445[_kkqtnloCbk]\u9519\u8bef\u3002<br \/>\n\u544a\u8b66\u65e5\u5fd7\u4e2d\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>Tue Nov 08 14:56:39 2011\r\nErrors in file c:\\oracle\\product\\10.2.0\\admin\\orcl\\udump\\orcl_ora_4720.trc:\r\nORA-07445: \u51fa\u73b0\u5f02\u5e38\u9519\u8bef: \u6838\u5fc3\u8f6c\u50a8 [ACCESS_VIOLATION] [_kkqtnloCbk+124] [PC:0x1DB818C] [ADDR:0xF5] [UNABLE_TO_READ] []<\/pre>\n<p>\u5bfc\u81f4\u8fd9\u4e2a\u9519\u8bef\u7684\u539f\u56e0\u662fOracle\u5904\u7406ANSI\u8bed\u6cd5\u65f6\u51fa\u73b0\u5f02\u5e38\uff0c\u53c2\u8003\u6587\u6863Bug 4204383  Dump [kkqtnlocbk] optimizing ANSI OUTER JOINs with subqueries\u3002<br \/>\n\u8fd9\u4e2a\u9519\u8bef\u5f71\u54cd10.2.0.3\u4ee5\u4e0b\u7248\u672c\uff0cOracle\u572810.2.0.4\u548c11.1.0.6\u4e2d\u5bf9\u8fd9\u4e2a\u95ee\u9898\u8fdb\u884c\u4e86\u4fee\u6b63\u3002<br \/>\n\u4e8b\u5b9e\u8bc1\u660e\uff0cOracle\u5bf9\u4e8eANSI\u7684\u6807\u51c6SQL\u5199\u6cd5\u7684\u652f\u6301\u66f4\u5bb9\u6613\u5b58\u5728\u95ee\u9898\uff0c\u5982\u679c\u6ca1\u6709\u660e\u786e\u7684\u8de8\u6570\u636e\u5e93\u9700\u6c42\uff0c\u5efa\u8bae\u4f7f\u7528Oracle\u81ea\u5df1\u7684SQL\u8bed\u6cd5\uff0c\u5c24\u5176\u662f\u5916\u8054\u63a5\u7684\u8bed\u6cd5\uff0c\u66f4\u662f\u5bb9\u6613\u51fa\u73b0\u95ee\u9898\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u623710.2.0.1 for Windows 32\u6570\u636e\u5e93\u51fa\u73b0ORA-7445[_kkqtnloCbk]\u9519\u8bef\u3002 \u544a\u8b66\u65e5\u5fd7\u4e2d\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a Tue Nov 08 14:56:39 2011 Errors in file c:\\oracle\\product\\10.2.0\\admin\\orcl\\udump\\orcl_ora_4720.trc: ORA-07445: \u51fa\u73b0\u5f02\u5e38\u9519\u8bef: \u6838\u5fc3\u8f6c\u50a8 [ACCESS_VIOLATION] [_kkqtnloCbk+124] [PC:0x1DB818C] [ADDR:0xF5] [UNABLE_TO_READ] [] \u5bfc\u81f4\u8fd9\u4e2a\u9519\u8bef\u7684\u539f\u56e0\u662fOracle\u5904\u7406ANSI\u8bed\u6cd5\u65f6\u51fa\u73b0\u5f02\u5e38\uff0c\u53c2\u8003\u6587\u6863Bug 4204383 Dump [kkqtnlocbk] optimizing ANSI OUTER JOINs with subqueries\u3002 \u8fd9\u4e2a\u9519\u8bef\u5f71\u54cd10.2.0.3\u4ee5\u4e0b\u7248\u672c\uff0cOracle\u572810.2.0.4\u548c11.1.0.6\u4e2d\u5bf9\u8fd9\u4e2a\u95ee\u9898\u8fdb\u884c\u4e86\u4fee\u6b63\u3002 \u4e8b\u5b9e\u8bc1\u660e\uff0cOracle\u5bf9\u4e8eANSI\u7684\u6807\u51c6SQL\u5199\u6cd5\u7684\u652f\u6301\u66f4\u5bb9\u6613\u5b58\u5728\u95ee\u9898\uff0c\u5982\u679c\u6ca1\u6709\u660e\u786e\u7684\u8de8\u6570\u636e\u5e93\u9700\u6c42\uff0c\u5efa\u8bae\u4f7f\u7528Oracle\u81ea\u5df1\u7684SQL\u8bed\u6cd5\uff0c\u5c24\u5176\u662f\u5916\u8054\u63a5\u7684\u8bed\u6cd5\uff0c\u66f4\u662f\u5bb9\u6613\u51fa\u73b0\u95ee\u9898\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[120,1151,118,72,1152,294,1150],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-kW","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1298"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1298"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1298\/revisions"}],"predecessor-version":[{"id":1299,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1298\/revisions\/1299"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1298"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1298"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1298"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}