{"id":78,"date":"2011-09-07T22:28:49","date_gmt":"2011-09-07T14:28:49","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=78"},"modified":"2011-09-22T18:28:36","modified_gmt":"2011-09-22T10:28:36","slug":"ora-600ksfdsyncdata2%e9%94%99%e8%af%af","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=78","title":{"rendered":"ORA-600(ksfdsyncdata2)\u9519\u8bef"},"content":{"rendered":"<p>\u5ba2\u6237\u7684\u544a\u8b66\u65e5\u5fd7\u4e2d\u53d1\u73b0\u4e86\u8fd9\u4e2aORA-600\u9519\u8bef\u3002<br \/>\n\u8be6\u7ec6\u7684\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n<pre lang='SQL'>Wed Jan 12 22:17:15 2011\r\nKCF: write\/open error block=0x3f6689 online=1\r\nfile=2 \/TEMP\/B1EDB\/temp02.dbf\r\nerror=27072 txt: 'HPUX-ia64 Error: 28: No space left on device\r\nAdditional information: 4\r\nAdditional information: 4155017\r\nAdditional information: -1'\r\nAutomatic tempfile offline due to write error on\r\nfile 2: \/TEMP\/B1EDB\/temp02.dbf\r\nWed Jan 12 22:17:16 2011\r\nErrors in file \/oracle\/db\/admin\/B1EDB\/bdump\/b1edb_j001_13014.trc:\r\nORA-00600: internal error code, arguments: [ksfdsyncdata2], [0xC000000335E58668], [], [], [], [], [], []\r\nORA-00372: file 302 cannot be modified at this time\r\nORA-01110: data file 302: '\/TEMP\/B1EDB\/temp02.dbf'\r\nORA-00372: file 302 cannot be modified at this time\r\nORA-01110: data file 302: '\/TEMP\/B1EDB\/temp02.dbf'\r\nWed Jan 12 22:17:18 2011\r\nErrors in file \/oracle\/db\/admin\/B1EDB\/bdump\/b1edb_j000_12908.trc:\r\nORA-12012: error on auto execute of job 8952\r\nORA-00376: file ORA-00376: file 302 cannot be read at this time\r\nORA-01110: data file 302: '\/TEMP\/B1EDB\/temp02.dbf'\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\ncannot be read at this time<\/pre>\n<p>\u8fd9\u4e2aORA-600\u9519\u8bef\u672c\u8eab\u6bd4\u8f83\u7f55\u89c1\uff0c\u5728\u6574\u4e2ametalink\u4e5f\u627e\u4e0d\u5230\u8bf4\u660e\uff0c\u4e0d\u8fc7\u7ed3\u5408\u7cfb\u7edf\u7684\u9519\u8bef\u4fe1\u606f\uff0c\u5230\u662f\u53ef\u4ee5\u5206\u6790\u51fa\u7cfb\u7edf\u7684\u95ee\u9898\u3002<br \/>\n\u663e\u7136\u5728ORA-600\u9519\u8bef\u51fa\u73b0\u4e4b\u524d\uff0c\u51fa\u73b0\u4e86\u4e34\u65f6\u8868\u7a7a\u95f4\u4e0d\u8db3\u7684\u95ee\u9898\u3002Oracle\u5bf9\u4e8e\u4e34\u65f6\u8868\u7a7a\u95f4\uff0c\u5e76\u4e0d\u4f1a\u60f3\u666e\u901a\u8868\u7a7a\u95f4\u90a3\u6837\u5c06\u6574\u4e2a\u6570\u636e\u6587\u4ef6\u8fdb\u884c\u521d\u59cb\u5316\uff0c\u800c\u662f\u5728\u771f\u6b63\u7528\u5230\u7684\u65f6\u5019\u518d\u53bb\u5206\u914d\u3002\u8fd9\u91cc\u7684\u95ee\u9898\u662f\uff0c\u4e34\u65f6\u6587\u4ef6\u6240\u5728\u64cd\u4f5c\u7cfb\u7edf\u76ee\u5f55\u4e0a\u7a7a\u95f4\u5df2\u7ecf\u88ab\u7528\u5149\uff0c\u800c\u5f53\u51fa\u73b0\u6392\u5e8f\u6216\u8fde\u63a5\u9700\u8981\u5206\u914d\u4e34\u65f6\u6bb5\u65f6\uff0c\u5728\u5199\u4e34\u65f6\u6587\u4ef6\u65f6\uff0c\u51fa\u73b0\u4e86\u9519\u8bef\u3002<\/p>\n<pre lang='SQL'>\/oracle\/db\/admin\/B1EDB\/bdump\/b1edb_j001_13014.trc\r\nOracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nORACLE_HOME = \/oracle\/db\r\nSystem name: HP-UX\r\nNode name: EDB\r\nRelease: B.11.23\r\nVersion: U\r\nMachine: ia64\r\nInstance name: B1EDB\r\nRedo thread mounted by this instance: 1\r\nOracle process number: 20\r\nUnix process pid: 13014, image: oracle@EDB (J001)\r\n\r\n*** ACTION NAME:(GATHER_STATS_JOB) 2011-01-12 22:17:16.421\r\n*** MODULE NAME:(DBMS_SCHEDULER) 2011-01-12 22:17:16.421\r\n*** SERVICE NAME:(SYS$USERS) 2011-01-12 22:17:16.421\r\n*** SESSION ID:(590.24179) 2011-01-12 22:17:16.421\r\n*** 2011-01-12 22:17:16.421\r\nksedmp: internal or fatal error\r\nORA-00600: internal error code, arguments: [ksfdsyncdata2], [0xC000000335E58668], [], [], [], [], [], []\r\nORA-00372: file 302 cannot be modified at this time\r\nORA-01110: data file 302: '\/TEMP\/B1EDB\/temp02.dbf'\r\nORA-00372: file 302 cannot be modified at this time\r\nORA-01110: data file 302: '\/TEMP\/B1EDB\/temp02.dbf'\r\nCurrent SQL statement for this session:\r\nselect i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$\/256),256)),ist.cachedblk,ist.cachehit,ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols,min(to_number(bitand(defer,1))) deferrable#,min(to_number(bitand(defer,4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#\r\n----- PL\/SQL Call Stack -----\r\n  object      line  object\r\n  handle    number  name\r\nc00000033d7f01d8       519  package body SYS.DBMS_STATS_INTERNAL\r\nc00000033d7f01d8       531  package body SYS.DBMS_STATS_INTERNAL\r\nc00000033ee5e870      8533  package body SYS.DBMS_STATS\r\nc00000033ee5e870      8580  package body SYS.DBMS_STATS\r\nc00000033ee5e870      8672  package body SYS.DBMS_STATS\r\nc00000033ee5e870      8752  package body SYS.DBMS_STATS\r\nc00000033ee5e870     12415  package body SYS.DBMS_STATS\r\nc00000033ee5e870     12892  package body SYS.DBMS_STATS\r\nc00000033ee5e870     13345  package body SYS.DBMS_STATS\r\nc00000033ee5e870     19409  package body SYS.DBMS_STATS\r\n----- Call Stack Trace -----\r\ncalling              call     entry                argument values in hex      \r\nlocation             type     point                (? means dubious value)     \r\n-------------------- -------- -------------------- ----------------------------\r\nksedst()+64          call     ksedst1()            000000000 ? 000000001 ?\r\nksedmp()+2176        call     ksedst()             000000000 ?\r\n                                                   C000000000000C9F ?\r\n                                                   400000000404CC40 ?\r\n                                                   000000000 ? 000000000 ?\r\n                                                   000000000 ?\r\nksfdmp()+48          call     ksedmp()             000000003 ?\r\nkgerinv()+304        call     ksfdmp()             C000000000000612 ?\r\n                                                   000000003 ?\r\n                                                   40000000094FF110 ?\r\n                                                   00001830B ? 000000000 ?\r\n                                                   000000000 ?\r\nkgesinv()+64         call     kgerinv()            6000000000031370 ?\r\n                                                   4000000001A4B3E0 ?\r\n                                                   6000000000032428 ?\r\n                                                   4000000001A4B3E0 ?\r\n                                                   9FFFFFFFFFFC5700 ?\r\nksesin()+176         call     kgesinv()            6000000000031370 ?\r\n                                                   60000000001E85A0 ?\r\n                                                   60000000001E85B0 ?\r\n                                                   60000000000327A0 ?\r\n                                                   9FFFFFFFFFFC5700 ?\r\n$cold_ksfdsyncdata(  call     ksesin()             4000000000F09090 ?\r\n)+256                                              000000001 ?\r\n                                                   60000000000C2790 ?\r\n                                                   9FFFFFFFFFFC5700 ?\r\n                                                   60000000000C2EC0 ?\r\n                                                   60000000000B5E18 ?\r\n                                                   C000000000000286 ?\r\n                                                   C000000000000998 ?\r\nkcflsync()+160       call     $cold_ksfdsyncdata(  C0000003356BF050 ?\r\n                              )                    C00000000000038C ?\r\n                                                   4000000002549860 ?\r\n                                                   C000000335E586B8 ?\r\n                                                   C0000003356BF070 ?<\/pre>\n<p>\u663e\u7136\uff0c\u8fd9\u662fJOB\u8c03\u7528\u7684DBMS_STATS\u6536\u96c6\u7edf\u8ba1\u4fe1\u606f\u7684\u4f1a\u8bdd\uff0c\u4ece\u9519\u8bef\u53d1\u751f\u7684\u65f6\u95f4\u4e0a\u770b\uff0c\u5bfc\u81f4\u4e34\u65f6\u7a7a\u95f4\u4e0d\u8db3\u7684\u591a\u534a\u4e5f\u662f\u6536\u96c6\u7edf\u8ba1\u4fe1\u606f\u7684\u8fc7\u7a0b\u3002\u663e\u7136\u8fd9\u4e2aORA-600\u7684\u9519\u8bef\uff0c\u6b63\u662f\u7531\u4e8eDBMS_STATS\u78b0\u5230\u4e86\u4e34\u65f6\u7a7a\u95f4\u4e0d\u8db3\u6240\u5bfc\u81f4\u7684\u3002<br \/>\n\u8fd9\u4e2a\u9519\u8bef\u6ca1\u6709\u4ec0\u4e48\u5371\u5bb3\uff0c\u53ea\u8981\u907f\u514d\u7a7a\u95f4\u4e0d\u8db3\u7684\u95ee\u9898\uff0c\u5c31\u53ef\u4ee5\u907f\u514d\u8fd9\u4e2aORA-600\u7684\u4ea7\u751f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5ba2\u6237\u7684\u544a\u8b66\u65e5\u5fd7\u4e2d\u53d1\u73b0\u4e86\u8fd9\u4e2aORA-600\u9519\u8bef\u3002 \u8be6\u7ec6\u7684\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a Wed Jan 12 22:17:15 2011 KCF: write\/open error block=0x3f6689 online=1 file=2 \/TEMP\/B1EDB\/temp02.dbf error=27072 txt: &#8216;HPUX-ia64 Error: 28: No space left on device Additional information: 4 Additional information: 4155017 Additional information: -1&#8217; Automatic tempfile offline due to write error &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=78\">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":[63,62,64,8,12],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-1g","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/78"}],"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=78"}],"version-history":[{"count":2,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/78\/revisions"}],"predecessor-version":[{"id":130,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/78\/revisions\/130"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=78"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=78"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=78"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}