trac文件分析求助

Question

Cursor#5(0D610D24) state=SYNTAX curiob=0A318BF0
 curflg=4c fl2=0 par=00000000 ses=6F31B534
 sqltxt(67D2347C)=
INSERT INTO TMPZWKMYEBDEC1_10001(F_DWBH,F_KMBH,F_FLAG,F_JS, F_JFSLFS, F_WBBH,F_JD,F_JFWBFS, F_JFJEFS)  SELECT LSDWCN_DWBH,ZWKMZD_KMBH,'x',ZWKMZD_JS, Round(Sum(Round(ZWPZFL_SL,2)),2), LSWBZD_BZBH,LSWBZD_JD, Round(Sum(Round(ZWPZFL_WB,LSWBZD_JD)),LSWBZD_JD), Round(Sum(Round(ZWPZFL_JE,2)),2)  FROM ZWPZK2010,ZWPZFL2010,ZWKMZD2010,TMPZWYEDW1DEC1_10001,LSWBZD WHERE  ZWPZK_DWBH=LSDWCN_DWBH AND LSDWCN_KMTX='01' AND LSDWCN_BWB='01' AND LSDWCN_KJRL='01' AND ZWPZK_ZFF='0' AND ZWPZK_WZF='1'  AND ZWPZFL_DWBH=LSDWCN_DWBH AND ZWPZK_PZNM=ZWPZFL_PZNM  AND ZWPZFL_KMBH=ZWKMZD_KMBH  AND ZWKMZD_TX='01'  AND ZWKMZD_KMBH>='22110101' AND ZWKMZD_KMBH<='22110101z'  AND (ZWKMZD_KMLX='1' or ZWKMZD_DWBH=LSDWCN_DWBH)  AND ZWPZFL_WBBH=LSWBZD_BZBH  AND ZWPZFL_JZFX='1' AND ZWPZK_KJND='2010'  AND ZWPZK_KJQJ>='03' AND ZWPZK_KJQJ<='03'  AND ZWKMZD_JS>=3 AND ZWPZK_JZF='0'  GROUP BY LSDWCN_DWBH,ZWKMZD_KMBH,ZWKMZD_JS,LSWBZD_BZBH,LSWBZD_JD
  hash=733b2d6eec2362077a53aac0164e067c
  parent=529D43F0 maxchild=01 plk=5BBE2C90 ppn=n
cursor instantiation=0A318BF0
 child#0(66BE0FB8) pcs=529D45F4
  clk=6B56F85C ci=5C14D154 pn=5BB030C4 ctx=6577053C
 kgsccflg=0 llk[0A318BF4,0A318BF4] idx=0
 xscflg=20024 fl2=0 fl3=2022000 fl4=0
 Frames pfr 00000000 siz=0 efr 00000000 siz=0
 Cursor frame dump
  enxt: 1.0x000001c4
  pnxt: 2.0x00000018  pnxt: 1.0x00000008求助各位以上sql为什么会产生ORA-00600: 内部错误代码, 参数: [15160], [], [], [], [], [], [], []错误

Answer 1

最好是把call stack 帖出来。

Answer 2

----- 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             6F89E840 3
_kgesiv+85           CALLrel  _kgeriv+0            6F89E840 E8F1F60 3B38 0
                                                   5E5BA070
_ksesic0+59          CALLrel  _kgesiv+0            6F89E840 E8F1F60 3B38 0
                                                   5E5BA070 3B38 0 5E5BA070
__VInfreq__kkotap+2  CALLrel  _ksesic0+0           3B38
8190                                               
_kkoqbc+3521         CALLrel  _kkoipt+0            9A649E8
_apakkoqb+151        CALLrel  _kkoqbc+0            8D83CC8 1
_apaqbd+383          CALLrel  _apakkoqb+0          5E5BBD38 E8B6190 6577053C
_apaqbd+171          CALLrel  _apaqbd+0            
_apadrv+459          CALLrel  _apaqbd+0            
_opitca+1445         CALLrel  _apadrv+0            6577053C
__PGOSF359__kksFull  CALLrel  _opitca+0            A318BF0 6577053C
TypeCheck+15                                       
_rpiswu2+426         CALLreg  00000000             5E5BC5BC
_kksLoadChild+5883   CALLrel  _rpiswu2+0           6F31B534 3D 5C14D190 13
                                                   5C14D35C 3D 5C14D1BC 0 5B4E9C
                                                   0 5E5BC5BC 0
_kkslod+98           CALLrel  _kksLoadChild+0      6F89E840 66BE0FB8 5E5BD3C8
_kglobld+837         CALLreg  00000000             6F89E840 66BE0FB8 5E5BD3C8
_kglobpn+1224        CALLrel  _kglobld+0           6F89E840 5C14D004 5E5BD3C8
                                                   5BB030C4 0
_kglpim+264          CALLrel  _kglobpn+0           6F89E840 5BB030C4 5E5BD3C8 1
_kglpin+1078         CALLrel  _kglpim+0            6F89E840 5E5BD3C8 5BB030C4
_kxsGetRuntimeLock+  CALLrel  _kglpin+0            6F89E840 5E5BD3C8 6B56F85C
1936                                               66BE0FB8 3 3 A318C18
_kksfbc+7232         CALLrel  _kxsGetRuntimeLock+  6F89E840 A318BF0 5E5BD3C8 3 1
                              0                    
_kkspsc0+2094        CALLrel  _kksfbc+0            A318BF0 3 108 9564D6C 391 0 0
                                                   0
_kksParseCursor+143  CALLrel  _kkspsc0+0           
_opiosq0+1965        CALLrel  _kksParseCursor+0    5E5BD8A4
_kpooprx+232         CALLrel  _opiosq0+0           3 E 5E5BD9DC A4
_kpoal8+775          CALLrel  _kpooprx+0           5E5BF6FC 9564D6C 390 1 0 A4
_opiodr+1099         CALLreg  00000000             5E 17 5E5BF6F8
_ttcpip+1273         CALLreg  00000000             5E 17 5E5BF6F8 0
_opitsk+1017         CALL???  00000000             
_opiino+1087         CALLrel  _opitsk+0            0 0
_opiodr+1099         CALLreg  00000000             3C 4 5E5BFC90
_opidrv+819          CALLrel  _opiodr+0            3C 4 5E5BFC90 0
_sou2o+45            CALLrel  _opidrv+0            3C 4 5E5BFC90
_opimai_real+112     CALLrel  _sou2o+0             5E5BFC84 3C 4 5E5BFC90
_opimai+92           CALLrel  _opimai_real+0       2 5E5BFCBC
_OracleThreadStart@  CALLrel  _opimai+0            
4+708                                              
7C826060             CALLreg  00000000             

Answer 3

还要 二进制转储内容吗？Binary Stack Dump 

Answer 4

不要挑战oracle极限,关联这么多表和条件,你可以分几步来实现啊

Answer 5

本帖最后由 inthirties 于 2010-03-04 12:35:14 编辑

  

Answer 6

楼上的正解，1。设置optimizer_features_enable=9.2.0 
或者 
2.打上oracle的补丁patch 5694466 ; 
或者 
3。在你的view sql语句中添加hint： NO_UNNEST 
但设置optimizer_features_enable=9.2.0 完后oracle会自动将参数改回。10.2.0

Answer 7

另外如何分析trc文件，各位有什么好的教程吗？》

Answer 8

这没什么教程哦。只要根据function去metalink去查啦。

Answer 9

好深奥的东西，话说trac文件我一直都没看懂过

Answer 10

查查metalink不就很容易解决吗

Answer 11

用 tkprof 来分析
http://space.itpub.net/22664653/viewspace-630641
希望对你有所帮助