{"id":1221,"date":"2012-09-26T23:28:42","date_gmt":"2012-09-26T15:28:42","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1221"},"modified":"2012-12-13T17:34:00","modified_gmt":"2012-12-13T09:34:00","slug":"ora-600504row-cache-objects%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1221","title":{"rendered":"ORA-600(504)(row cache objects)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u6237\u6570\u636e\u5e93\u51fa\u73b0ORA-600(504)\u9519\u8bef\uff0c\u5176\u4e2d\u7b2c5\u4e2a\u9519\u8bef\u53c2\u6570\u4e3arow cache objects\u3002<br \/>\n\u4ee5\u524d\u78b0\u5230\u8fc7\u4e00\u4e2ashared pool\u7684\u76f8\u5173latch\uff1ahttp:\/\/yangtingkun.itpub.net\/post\/468\/526079<br \/>\n\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>Wed Apr 18 06:03:41 2012\r\nErrors in file \/data\/oracle\/admin\/orcl\/udump\/orcl_ora_19038.trc:\r\nORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801\uff0c\u53c2\u6570: [504], [0x4628BD7A0], [32], [4], [row cache objects], [10], [2], [0x000000000]<\/pre>\n<p>\u6570\u636e\u5e93\u7248\u672c\u4e3a9.2.0.6\uff0c\u6839\u636eMOS\u6587\u6863\uff0c\u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\u662f\u67e5\u8be2\u4e86V$SQL_PLAN\u89c6\u56fe\uff0c\u4e14\u5f53\u524d\u4f1a\u8bdd\u5df2\u7ecf\u6301\u6709\u4e86\u4e00\u4e2a\u4e0d\u517c\u5bb9\u7684library cache latch\u3002<br \/>\nOracle\u7ed9\u51fa\u7684\u89e3\u51b3\u65b9\u6cd5\u53ea\u6709\u5347\u7ea7\u523010.2.0.1\uff0c\u5bf9\u4e8e10.2\u4ee5\u4e0b\u7684\u7248\u672c\uff0c\u53ef\u4ee5\u8003\u8651\u8bbe\u7f6e\u9690\u542b\u53c2\u6570_cursor_plan_unparse_enabled\u7684\u503c\u4e3afalse\u6765\u89e3\u51b3\u8be5\u95ee\u9898\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u6237\u6570\u636e\u5e93\u51fa\u73b0ORA-600(504)\u9519\u8bef\uff0c\u5176\u4e2d\u7b2c5\u4e2a\u9519\u8bef\u53c2\u6570\u4e3arow cache objects\u3002 \u4ee5\u524d\u78b0\u5230\u8fc7\u4e00\u4e2ashared pool\u7684\u76f8\u5173latch\uff1ahttp:\/\/yangtingkun.itpub.net\/post\/468\/526079 \u9519\u8bef\u4fe1\u606f\u4e3a\uff1a Wed Apr 18 06:03:41 2012 Errors in file \/data\/oracle\/admin\/orcl\/udump\/orcl_ora_19038.trc: ORA-00600: \u5185\u90e8\u9519\u8bef\u4ee3\u7801\uff0c\u53c2\u6570: [504], [0x4628BD7A0], [32], [4], [row cache objects], [10], [2], [0x000000000] \u6570\u636e\u5e93\u7248\u672c\u4e3a9.2.0.6\uff0c\u6839\u636eMOS\u6587\u6863\uff0c\u5bfc\u81f4\u95ee\u9898\u7684\u539f\u56e0\u662f\u67e5\u8be2\u4e86V$SQL_PLAN\u89c6\u56fe\uff0c\u4e14\u5f53\u524d\u4f1a\u8bdd\u5df2\u7ecf\u6301\u6709\u4e86\u4e00\u4e2a\u4e0d\u517c\u5bb9\u7684library cache latch\u3002 Oracle\u7ed9\u51fa\u7684\u89e3\u51b3\u65b9\u6cd5\u53ea\u6709\u5347\u7ea7\u523010.2.0.1\uff0c\u5bf9\u4e8e10.2\u4ee5\u4e0b\u7684\u7248\u672c\uff0c\u53ef\u4ee5\u8003\u8651\u8bbe\u7f6e\u9690\u542b\u53c2\u6570_cursor_plan_unparse_enabled\u7684\u503c\u4e3afalse\u6765\u89e3\u51b3\u8be5\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":[415,8,1080,1081,1082],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-jH","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1221"}],"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=1221"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1221\/revisions"}],"predecessor-version":[{"id":1222,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1221\/revisions\/1222"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}