{"id":1273,"date":"2012-10-17T23:16:40","date_gmt":"2012-10-17T15:16:40","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=1273"},"modified":"2013-03-09T22:20:17","modified_gmt":"2013-03-09T14:20:17","slug":"ora-7445qsmmixcomputeclusteringfactor%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=1273","title":{"rendered":"ORA-7445(qsmmixComputeClusteringFactor)\u9519\u8bef"},"content":{"rendered":"<p>Oracle 11.2.0.2\u4e0aSQL TUNING\u7684bug\u3002<br \/>\n\u6570\u636e\u5e93\u7248\u672c\u4e3a11.2.0.2 RAC for Solaris\uff0c\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>Thu Jul 05 22:00:01 2012\r\nBegin automatic SQL Tuning Advisor run for special tuning task  \"SYS_AUTO_SQL_TUNING_TASK\"\r\nThu Jul 05 22:28:35 2012\r\nException [type: SIGSEGV, Address not mapped to object] [ADDR:0x4] [PC:0x102B3CC08, qsmmixComputeClusteringFactor()+1640] [flags: 0x0, count: 1]\r\nErrors in file \/opt\/oracle\/app\/oracle\/diag\/rdbms\/orcl\/orcl1\/trace\/orcl1_j002_7688.trc  (incident=192450):\r\nORA-07445: exception encountered: core dump [qsmmixComputeClusteringFactor()+1640] [SIGSEGV] [ADDR:0x4] [PC:0x102B3CC08] [Address not mapped to object] []\r\nIncident details in: \/opt\/oracle\/app\/oracle\/diag\/rdbms\/orcl\/orcl1\/incident\/incdir_192450\/orcl1_j002_7688_i192450.trc\r\nUse ADRCI or Support Workbench to package the incident.\r\nSee Note 411.1 at My Oracle Support for error and packaging details.\r\nThu Jul 05 22:28:38 2012\r\nDumping diagnostic data in directory=[cdmp_20120705222838], requested by (instance=1, osid=7688 (J002)), summary=[incident=192450].\r\nThu Jul 05 22:28:41 2012\r\nSweep [inc][192450]: completed\r\nSweep [inc2][192450]: completed<\/pre>\n<p>\u4e0d\u9700\u8981\u5176\u4ed6\u4fe1\u606f\uff0c\u4e0a\u9762\u7684\u62a5\u9519\u5c31\u8db3\u4ee5\u5224\u65ad\uff0c\u95ee\u9898\u53d1\u751f\u5728SQL TUNING\u81ea\u52a8\u8fd0\u884c\u7684JOB\u4e2d\u3002\u663e\u7136\u8fd9\u662fOracle\u7684bug\u3002<br \/>\n\u679c\u7136MOS\u6587\u6863Bug 9746210 &#8211; ORA-7445 [qsmmixComputeClusteringFactor] from SQL tuning [ID 9746210.8]\u63cf\u8ff0\u4e86\u8fd9\u4e2a\u95ee\u9898\uff0c\u4e14\u786e\u8ba4\u5f71\u54cd\u7248\u672c\u5c31\u662f11.2.0.2\u3002Oracle\u572811.2.0.3\u548c11.2.0.2.4\u4e2d\u4fee\u6b63\u4e86\u8fd9\u4e2a\u95ee\u9898\u3002<br \/>\n\u8fd9\u4e2a\u95ee\u9898\u5bf9\u4e8e\u6570\u636e\u5e93\u7684\u8fd0\u884c\u672c\u8eab\u4e5f\u6ca1\u6709\u4ec0\u4e48\u5f71\u54cd\uff0c\u53ef\u4ee5\u76f4\u63a5\u5ffd\u7565\u6389\uff0c\u751a\u81f3\u53ef\u4ee5\u5c06SQL TUNING\u5bf9\u5e94\u7684SCHEDULER\u76f4\u63a5\u505c\u6b62\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle 11.2.0.2\u4e0aSQL TUNING\u7684bug\u3002 \u6570\u636e\u5e93\u7248\u672c\u4e3a11.2.0.2 RAC for Solaris\uff0c\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a Thu Jul 05 22:00:01 2012 Begin automatic SQL Tuning Advisor run for special tuning task &#8220;SYS_AUTO_SQL_TUNING_TASK&#8221; Thu Jul 05 22:28:35 2012 Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x4] [PC:0x102B3CC08, qsmmixComputeClusteringFactor()+1640] [flags: &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=1273\">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":[118,1119,1120,706],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-kx","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1273"}],"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=1273"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1273\/revisions"}],"predecessor-version":[{"id":1274,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/1273\/revisions\/1274"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1273"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1273"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}