*** SERVICE NAME:(ora10g) 2009-10-16 14:53:42.246
*** SESSION ID:(130.40343) 2009-10-16 14:53:42.246
*** 2009-10-16 14:53:42.246
ksedmp: internal or fatal error
ORA-00600: 内部错误代码, 参数: [15160], [], [], [], [], [], [], []
Current SQL statement for this session:
 INSERT INTO TMPZWKMYEBE341_09001(F_DWBH,F_KMBH,F_NCJFJEYE,F_JFJELJ,F_DFJELJ,F_DQJFJEYE,F_JFJEFS,F_DFJEFS  )SELECT LSDWCN_DWBH,ZWKMYE_KMBH, Round(Sum(Round(ZWKMYE_NCYE,2)),2), Round(Sum(Round(ZWKMYE_JFLJ,2)),2), Round(Sum(Round(ZWKMYE_DFLJ,2)),2), Round(Sum(Round(ZWKMYE_DQYE,2)),2), case when LSDWCN_KJQJ>='01' then Round(Sum(Round(ZWKMYE_JFFS,2)),2) else 0 end, case when LSDWCN_KJQJ>='01' then Round(Sum(Round(ZWKMYE_DFFS,2)),2) else 0 end  FROM ZWKMYE2009,ZWKMZD2009,TMPZWYEDW1E341_09001 WHERE ZWKMYE_KJND='2009' AND ZWKMYE_KJQJ=LSDWCN_KJQJ  AND ZWKMYE_DWBH=LSDWCN_DWBH AND LSDWCN_KMTX='01' AND LSDWCN_BWB='01' AND LSDWCN_KJRL='01'  AND ZWKMYE_KMBH=ZWKMZD_KMBH  AND ZWKMZD_TX='01'  AND ZWKMZD_KMBH>='1002010201' AND ZWKMZD_KMBH<='1002010201z'  AND (ZWKMZD_KMLX='1' or ZWKMZD_DWBH=LSDWCN_DWBH)  AND ZWKMZD_JS>='4' AND ZWKMZD_JS<='5'  GROUP BY LSDWCN_DWBH,ZWKMYE_KMBH,LSDWCN_KJQJ
----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------
_ksedst+38           CALLrel  _ksedst1+0           0 1
_ksedmp+898          CALLrel  _ksedst+0            0
_ksfdmp+14           CALLrel  _ksedmp+0            3
_kgeriv+146          CALLreg  00000000             37AE1ED0 3
_kgesiv+85           CALLrel  _kgeriv+0            37AE1ED0 10311F60 3B38 0
                                                   32A2A070
_ksesic0+59          CALLrel  _kgesiv+0            37AE1ED0 10311F60 3B38 0
                                                   32A2A070 3B38 0 32A2A070
__VInfreq__kkotap+2  CALLrel  _ksesic0+0           3B38
8190                                               
_kkoqbc+3521         CALLrel  _kkoipt+0            8C8B8DC
_apakkoqb+151        CALLrel  _kkoqbc+0            9A64CF8 1
_apaqbd+383          CALLrel  _apakkoqb+0          32A2BD38 101D6208 664AD72C
_apaqbd+171          CALLrel  _apaqbd+0            
_apadrv+459          CALLrel  _apaqbd+0            
_opitca+1445         CALLrel  _apadrv+0            664AD72C
__PGOSF359__kksFull  CALLrel  _opitca+0            3209AB18 664AD72C
TypeCheck+15                                       
_rpiswu2+426         CALLreg  00000000             32A2C5BC
_kksLoadChild+5883   CALLrel  _rpiswu2+0           7EB5025C 3D 7241FE88 13
                                                   72420054 3D 7241FEB4 0 5B4E9C
                                                   0 32A2C5BC 0
_kkslod+98           CALLrel  _kksLoadChild+0      37AE1ED0 1546694C 32A2D3C8
_kglobld+837         CALLreg  00000000             37AE1ED0 1546694C 32A2D3C8
_kglobpn+1224        CALLrel  _kglobld+0           37AE1ED0 7241FCFC 32A2D3C8
                                                   642A17B0 0
_kglpim+264          CALLrel  _kglobpn+0           37AE1ED0 642A17B0 32A2D3C8 1
_kglpin+1078         CALLrel  _kglpim+0            37AE1ED0 32A2D3C8 642A17B0
_kxsGetRuntimeLock+  CALLrel  _kglpin+0            37AE1ED0 32A2D3C8 DD6E004
1936                                               1546694C 3 3 3209AB40
_kksfbc+7232         CALLrel  _kxsGetRuntimeLock+  37AE1ED0 3209AB18 32A2D3C8 3
                              0                    1
_kkspsc0+2094        CALLrel  _kksfbc+0            3209AB18 3 108 7EEE500 372 0
                                                   0 0
_kksParseCursor+143  CALLrel  _kkspsc0+0           
_opiosq0+1965        CALLrel  _kksParseCursor+0    32A2D8A4
_kpooprx+232         CALLrel  _opiosq0+0           3 E 32A2D9DC A4
_kpoal8+775          CALLrel  _kpooprx+0           32A2F6FC 7EEE500 371 1 0 A4
_opiodr+1099         CALLreg  00000000             5E 17 32A2F6F8
_ttcpip+1273         CALLreg  00000000             5E 17 32A2F6F8 0
_opitsk+1017         CALL???  00000000             
_opiino+1087         CALLrel  _opitsk+0            0 0
_opiodr+1099         CALLreg  00000000             3C 4 32A2FC90
_opidrv+819          CALLrel  _opiodr+0            3C 4 32A2FC90 0
_sou2o+45            CALLrel  _opidrv+0            3C 4 32A2FC90
_opimai_real+112     CALLrel  _sou2o+0             32A2FC84 3C 4 32A2FC90
_opimai+92           CALLrel  _opimai_real+0       2 32A2FCBC
_OracleThreadStart@  CALLrel  _opimai+0            
4+708                                              
7C826060             CALLreg  00000000             
 

解决方案 »

  1.   

    http://www.oraclekonsulent.dk/en/index.php?blog_id=76
      

  2.   

    http://www.inthirties.com/thread-284-1-1.html
      

  3.   


    应该是10g吧。 他的service起名是 ora10g,不过小版本不知道,*** SERVICE NAME:(ora10g) 2009-10-16 14:53:42.246 
      

  4.   

    版本是10.2.0.1,我目前将 optimizer_features_enable参数调整到9.2.0不知道会不会有效。期待结果中。令:感谢1楼 2楼的资料提供,待问题解决就发分。不知还有没有能够帮忙的老师呵呵?
      

  5.   

    try:Setting "_optimizer_push_pred_cost_based" to FALSE.
      

  6.   

    先设置这个隐含参数,看看效果如何,否则需要升级至10204并bundle patch 4
      

  7.   

    thnk you very much ! try it and later give the results