{"id":817,"date":"2012-05-06T23:23:05","date_gmt":"2012-05-06T15:23:05","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=817"},"modified":"2012-05-09T09:25:46","modified_gmt":"2012-05-09T01:25:46","slug":"9i%e5%87%ba%e7%8e%b0%e5%86%85%e5%ad%98%e5%88%86%e9%85%8d%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=817","title":{"rendered":"9i\u51fa\u73b0\u5185\u5b58\u5206\u914d\u9519\u8bef"},"content":{"rendered":"<p>\u57289.2.0.8 RAC\u73af\u5883\u4e2d\uff0c\u544a\u8b66\u65e5\u5fd7\u9891\u7e41\u51fa\u73b0\u5185\u5b58\u5206\u914d\u9519\u8bef\u7684\u4fe1\u606f\u3002<br \/>\n\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Wed May 2 10:20:43 2012\r\nTrace dumping is performing id=[cdmp_20120502102043]\r\nThere are 1444 memory allocation errors for object-level stat\r\nin the last 15 minutes\r\n.\r\n.\r\n.\r\nThere are 1605 memory allocation errors for object-level stat\r\nin the last 15 minutes<\/pre>\n<p>\u5728\u53e6\u5916\u4e00\u4e2a\u8282\u70b9\u4e0a\u5219\u51fa\u73b0\u4e86ORA-4031\u9519\u8bef\uff1a<\/p>\n<pre lang='SQL'>Sun Apr 29 22:30:52 2012\r\nErrors in file \/oracle\/admin\/orcl\/bdump\/orcl2_j000_1204632.trc:\r\nORA-12012: error on auto execute of job 527\r\nORA-04031: unable to allocate 4224 bytes of shared memory (\"shared pool\",\"unknown object\",\"sga heap(2,0)\",\"object level s\")\r\nORA-06512: at \"PERFSTAT.STATSPACK\", line 2479\r\nORA-06512: at \"PERFSTAT.STATSPACK\", line 91\r\nORA-06512: at line 1\r\nSun Apr 29 23:03:14 2012\r\nErrors in file \/oracle\/admin\/orcl\/bdump\/orcl2_j001_1528536.trc:\r\nORA-12012: error on auto execute of job 527\r\nORA-04031: unable to allocate 4256 bytes of shared memory (\"shared pool\",\"unknown object\",\"sga heap(2,0)\",\"obj stat memor\")\r\nORA-06512: at \"PERFSTAT.STATSPACK\", line 2479\r\nORA-06512: at \"PERFSTAT.STATSPACK\", line 91\r\nORA-06512: at line 1\r\nThere is 1 memory allocation error for object-level stat\r\nin the last 15 minutes\r\nThere are 66 memory allocation errors for object-level stat\r\nin the last 15 minutes\r\nThere are 8 memory allocation errors for object-level stat\r\nin the last 15 minutes\r\nMon Apr 30 00:07:38 2012\r\nErrors in file \/oracle\/admin\/orcl\/bdump\/orcl2_j001_942754.trc:\r\nORA-12012: error on auto execute of job 527\r\nORA-04031: unable to allocate 4256 bytes of shared memory (\"shared pool\",\"unknown object\",\"sga heap(2,0)\",\"obj stat memor\")\r\nORA-06512: at \"PERFSTAT.STATSPACK\", line 2479\r\nORA-06512: at \"PERFSTAT.STATSPACK\", line 91\r\nORA-06512: at line 1\r\nThere are 354 memory allocation errors for object-level stat\r\nin the last 15 minutes\r\nThere are 653 memory allocation errors for object-level stat\r\nin the last 15 minutes\r\nMon Apr 30 02:07:45 2012\r\nThread 2 advanced to log sequence 71531\r\nCurrent log# 5 seq# 71531 mem# 0: \/dev\/rlv_redo22_128m\r\nMon Apr 30 02:07:45 2012\r\nARC0: Evaluating archive log 4 thread 2 sequence 71530\r\nARC0: Beginning to archive log 4 thread 2 sequence 71530\r\nCreating archive destination LOG_ARCHIVE_DEST_1: '\/archive2\/2_71530.dbf'\r\nARC0: Completed archiving log 4 thread 2 sequence 71530\r\nThere are 41 memory allocation errors for object-level stat\r\nin the last 15 minutes<\/pre>\n<p>ORA-4031\u9519\u8bef\u6bd4\u8f83\u5e38\u89c1\uff0c\u7b80\u5355\u7684\u8bf4\u5c31\u662f\u5185\u5b58\u4e0d\u8db3\u6240\u81f4\u3002\u4ece\u4e0a\u9762\u7684\u9519\u8bef\u4fe1\u606f\u770b\uff0c\u5185\u5b58\u4e0d\u8db3\u53d1\u751f\u5728\u5171\u4eab\u6c60\u4e0a\u3002\u800cMemory allocation errors\u540c\u6837\u662f\u5171\u4eab\u6c60\u7a7a\u95f4\u4e0d\u8db3\u7684\u8868\u73b0\uff0c\u53ef\u4ee5\u53c2\u8003\u6587\u7ae0Memory Allocation Errors For Object-Level Stat Appearing in the Alert Log File [ID 757895.1]\u3002<br \/>\n\u9488\u5bf9\u8fd9\u4e2a\u95ee\u9898\uff0c\u53ef\u4ee5\u901a\u8fc7\u8bbe\u7f6e\u9690\u542b\u53c2\u6570_OBJECT_STATISTICS=FALSE\u6765\u7981\u7528\u5bf9\u8c61\u7ea7\u7edf\u8ba1\u4fe1\u606f\uff0c\u4f46\u662f\u6700\u5f7b\u5e95\u7684\u65b9\u6cd5\u8fd8\u662f\u589e\u52a0\u5171\u4eab\u6c60\u7a7a\u95f4\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u57289.2.0.8 RAC\u73af\u5883\u4e2d\uff0c\u544a\u8b66\u65e5\u5fd7\u9891\u7e41\u51fa\u73b0\u5185\u5b58\u5206\u914d\u9519\u8bef\u7684\u4fe1\u606f\u3002 \u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a Wed May 2 10:20:43 2012 Trace dumping is performing id=[cdmp_20120502102043] There are 1444 memory allocation errors for object-level stat in the last 15 minutes . . . There are 1605 memory allocation errors for object-level stat in &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=817\">Continue reading <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":{"_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":[243,244,442,245],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-db","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/817"}],"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=817"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/817\/revisions"}],"predecessor-version":[{"id":818,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/817\/revisions\/818"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=817"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=817"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}