{"id":545,"date":"2012-02-05T23:56:07","date_gmt":"2012-02-05T15:56:07","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=545"},"modified":"2012-02-06T11:52:47","modified_gmt":"2012-02-06T03:52:47","slug":"ora-600ktspnextl14%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=545","title":{"rendered":"ORA-600(ktspNextL1:4)\u9519\u8bef"},"content":{"rendered":"<p>\u544a\u8b66\u65e5\u5fd7\u51fa\u73b0ORA-600[ktspNextL1:4]\u9519\u8bef\u3002<br \/>\n\u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>Tue Jan 15 22:00:45 2012\r\nErrors in file \/oracle\/admin\/orcl\/bdump\/orcl_j000_13722891.trc:\r\nORA-00600: internal error code, arguments: [ktspNextL1:4], [], [], [], [], [], [], []\r\nTue Jan 15 22:01:10 2012\r\nTrace dumping is performing id=[cdmp_20120131220118]\r\nTue Jan 15 22:01:10 2012\r\nErrors in file \/oracle\/admin\/orcl\/bdump\/ orcl_j000_13722891.trc:\r\nORA-00600: internal error code, arguments: [ORA-00600: internal error code, arguments: [ktspNextL1:4], [], [], [], [], [], [], []\r\nORA-06512: at \"SYS.PRVT_ADVISOR\", line 1624\r\nORA-06512: at \"SYS.DBMS_ADVISOR\", line 186\r\nORA-06512: at \"SYS.DBMS_SPACE\", line 1500\r\nORA-06512: at \"SYS.DBMS_SPACE\", line 1566\r\n], [], [], [], [], [], [], []<\/pre>\n<p>\u8be6\u7ec6TRACE\u6587\u4ef6\u5982\u4e0b\uff1a<\/p>\n<pre lang='SQL'>*** 2012-01-15 22:00:45 2012\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [ktspNextL1:4], [], [], [], [], [], [], []\r\nCurrent SQL statement for this session:\r\ninsert into wri$_adv_objspace_trend_data select timepoint,  space_usage, space_alloc, quality from  table(dbms_space.object_growth_trend(:1, :2, :3, :4, NULL, NULL,  NULL, 'FALSE', :5, 'FALSE'))\r\n----- PL\/SQL Call Stack -----\r\n  object      line  object\r\n  handle    number  name\r\n70000010d9a65e0      1834  package body SYS.DBMS_SPACE\r\n70000010d9a65e0      3922  package body SYS.DBMS_SPACE\r\n70000010d9a65e0      4233  package body SYS.DBMS_SPACE\r\n70000011a7d9c88         1  anonymous block\r\n700000180678048       344  SYS.WRI$_ADV_OBJSPACE_TREND_T\r\n700000180678048      1485  SYS.WRI$_ADV_OBJSPACE_TREND_T\r\n7000001334867d0      1535  package body SYS.PRVT_ADVISOR\r\n7000001334867d0      1618  package body SYS.PRVT_ADVISOR\r\n70000011f9f64a8       186  package body SYS.DBMS_ADVISOR\r\n70000010d9a65e0      1500  package body SYS.DBMS_SPACE\r\n70000010d9a65e0      1566  package body SYS.DBMS_SPACE\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedst+001c          bl       ksedst1              70000017E9975D0 ? 100000001 ?\r\nksedmp+0290          bl       ksedst               104A2CDB0 ?\r\nksfdmp+0018          bl       03F2735C             \r\nkgerinv+00dc         bl       _ptrgl               \r\nkgeasnmierr+004c     bl       kgerinv              000000000 ? 000000001 ?\r\n                                                   000000005 ? 7000000E19760FC ?\r\n                                                   7000000E1976014 ?\r\nktspGetNextL1ForSca  bl       01F94828             n+0104<\/pre>\n<p>\u663e\u7136\u8fd9\u53c8\u662f\u4e00\u4e2aORACLE\u5185\u90e8\u7684bug\uff0c\u4ecd\u7136\u662f\u5b9a\u65f6\u4efb\u52a1\u5bfc\u81f4\u7684\uff0cOracle\u5728\u8fdb\u884c\u7a7a\u95f4\u8d8b\u52bf\u5206\u6790\u7684\u65f6\u5019\u51fa\u73b0\u4e86\u8fd9\u4e2a\u9519\u8bef\u3002<br \/>\nOracle\u5728\u6587\u6863ORA-600 [ktspNextL1:4] from SYS.DBMS_SPACE \/ SYS.DBMS_ADVISOR\/WRI$_ADV_OBJSPACE_TREND_DATA [ID 841158.1]\u63cf\u8ff0\u4e86\u8fd9\u4e2a\u95ee\u9898\uff0c\u7ed9\u51fa\u7684\u89e3\u51b3\u65b9\u6848\u7b80\u5355\u7c97\u66b4\u3002\u65b9\u6848\u4e00\u3001\u5ffd\u7565\u9519\u8bef\uff1b\u65b9\u6848\u4e8c\u3001\u5347\u7ea7\u523011.1.0.7\uff1b\u65b9\u6848\u4e09\u3001\u91cd\u65b0\u6267\u884cJOB\u3002\u8fd9\u4e2a\u95ee\u9898\u5f71\u54cd\u4e0d\u5927\uff0c\u800c\u4e14\u5e76\u975e\u6bcf\u6b21\u90fd\u80fd\u91cd\u65b0\uff0c\u56e0\u6b64\u89e3\u51b3\u65b9\u6848\u8fd8\u7b97\u9760\u8c31\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u544a\u8b66\u65e5\u5fd7\u51fa\u73b0ORA-600[ktspNextL1:4]\u9519\u8bef\u3002 \u9519\u8bef\u4fe1\u606f\u5982\u4e0b\uff1a Tue Jan 15 22:00:45 2012 Errors in file \/oracle\/admin\/orcl\/bdump\/orcl_j000_13722891.trc: ORA-00600: internal error code, arguments: [ktspNextL1:4], [], [], [], [], [], [], [] Tue Jan 15 22:01:10 2012 Trace dumping is performing id=[cdmp_20120131220118] Tue Jan 15 22:01:10 2012 Errors &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=545\">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":[182,438,439,8],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-8N","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/545"}],"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=545"}],"version-history":[{"count":1,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/545\/revisions"}],"predecessor-version":[{"id":546,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/545\/revisions\/546"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=545"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}