oracle ora-00600:内部错误代码怎么解决

Question

我对一个视图进行 group by  总数,运行好久就 出错下列提示
ora-00600:内部错误代码，参数:[15160],[],[],[],[],[],[],[]

Answer 1

看看alert.log告警日志，才能确定原因。

Answer 2

trc文件的一部分ORA-00600: 内部错误代码, 参数: [15160], [], [], [], [], [], [], []
Current SQL statement for this session:
select * from v_tj_bdz_byqtj t
----- 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             8AD8E90 3
_kgesiv+85           CALLrel  _kgeriv+0            8AD8E90 7FB1F60 3B38 0
                                                   80CA3F0
_ksesic0+59          CALLrel  _kgesiv+0            8AD8E90 7FB1F60 3B38 0
                                                   80CA3F0 3B38 0 80CA3F0
__VInfreq__kkotap+2  CALLrel  _ksesic0+0           3B38
8190                                               
_kkoqbc+3521         CALLrel  _kkoipt+0            8D6F984
_apakkoqb+151        CALLrel  _kkoqbc+0            80CBC44 603AEE54
_apaqbd+383          CALLrel  _apakkoqb+0          80CC064 7FAA6B4 30CAC374
_apadrv+459          CALLrel  _apaqbd+0            
_opitca+1445         CALLrel  _apadrv+0            30CAC374
_kksLoadChild+5750   CALLrel  _opitca+0            80FA13C 30CAC374
_kkslod+98           CALLrel  _kksLoadChild+0      8AD8E90 33D7D534 80CD3C4
_kglobld+837         CALLreg  00000000             8AD8E90 33D7D534 80CD3C4
_kglobpn+1224        CALLrel  _kglobld+0           8AD8E90 2FEFF75C 80CD3C4
                                                   31B18348 0
_kglpim+264          CALLrel  _kglobpn+0           8AD8E90 31B18348 80CD3C4 1
_kglpin+1078         CALLrel  _kglpim+0            8AD8E90 80CD3C4 31B18348
_kxsGetRuntimeLock+  CALLrel  _kglpin+0            8AD8E90 80CD3C4 31B9A8D4
1936                                               33D7D534 3 3 80FA164
_kksfbc+7232         CALLrel  _kxsGetRuntimeLock+  8AD8E90 80FA13C 80CD3C4 3 1
                              0                    
_kkspsc0+2094        CALLrel  _kksfbc+0            80FA13C 3 108 80CE274 20 0 0
                                                   0
_kksParseCursor+143  CALLrel  _kkspsc0+0           
_opiosq0+1965        CALLrel  _kksParseCursor+0    80CD8A0
_kpooprx+232         CALLrel  _opiosq0+0           3 E 80CD9D8 A4
_kpoal8+775          CALLrel  _kpooprx+0           80CF6F8 80CE274 1F 1 0 A4
_opiodr+1099         CALLreg  00000000             5E 17 80CF6F4
_ttcpip+1273         CALLreg  00000000             5E 17 80CF6F4 0
_opitsk+1017         CALL???  00000000             
_opiino+1087         CALLrel  _opitsk+0            0 0
_opiodr+1099         CALLreg  00000000             3C 4 80CFC8C
_opidrv+819          CALLrel  _opiodr+0            3C 4 80CFC8C 0
_sou2o+45            CALLrel  _opidrv+0            3C 4 80CFC8C
_opimai_real+112     CALLrel  _sou2o+0             80CFC80 3C 4 80CFC8C
_opimai+92           CALLrel  _opimai_real+0       2 80CFCB8
_OracleThreadStart@  CALLrel  _opimai+0            
4+708                                              
7C80B680             CALLreg  00000000             
 
--------------------- Binary Stack Dump ---------------------
 
========== FRAME [1] (_ksedst+38 -> _ksedst1+0) ==========
Dump of memory from 0x080CA298 to 0x080CA2A8
80CA290                   080CA2A8 0040468B          [.....F@.]
80CA2A0 00000000 00000001                    [........]        
========== FRAME [2] (_ksedmp+898 -> _ksedst+0) ==========
Dump of memory from 0x080CA2A8 to 0x080CA368
80CA2A0                   080CA368 00403083          [h....0@.]
80CA2B0 00000000 080CA770 08D6F984 014465A5  [....p........eD.]
80CA2C0 08D6F984 FFFFFFFF 7FEFFFFF 00000001  [................]
80CA2D0 08CEC018 00000005 08AD8F94 00000000  [................]
80CA2E0 08AD8F8C 00000000 00000000 00000000  [................]
80CA2F0 00000000 00000000 08AD8F94 00000000  [................]
80CA300 00000000 080CA320 00000001 00000005  [.... ...........]
80CA310 00000000 00000000 00000000 080CA3F0  [................]
80CA320 36313531 00000001 00000000 00000000  [1516............]
80CA330 00000000 00000001 00000000 00000000  [................]
80CA340 08AD8E90 07FB1F60 031DAC40 00000005  [....`...@.......]
80CA350 080CA2B4 080CA390 080CC2D0 0261348C  [.............4a.]
80CA360 031C1800 FFFFFFFF                    [........]        
========== FRAME [3] (_ksfdmp+14 -> _ksedmp+0) ==========
Dump of memory from 0x080CA368 to 0x080CA374
80CA360                   080CA374 0043AB6F          [t...o.C.]
80CA370 00000003                             [....]            
========== FRAME [4] (_kgeriv+146 -> 00000000) ==========
Dump of memory from 0x080CA374 to 0x080CA390
80CA370          080CA390 603A816C 08AD8E90      [....l.:`....]
80CA380 00000003 08AD8E90 07FB1F60 08AD8A30  [........`...0...]
========== FRAME [5] (_kgesiv+85 -> _kgeriv+0) ==========
Dump of memory from 0x080CA390 to 0x080CA3B4
80CA390 080CA3B4 603A8404 08AD8E90 07FB1F60  [......:`....`...]
80CA3A0 00003B38 00000000 080CA3F0 08D6FE5C  [8;..........\...]
80CA3B0 080CA3F0                             [....]            
========== FRAME [6] (_ksesic0+59 -> _kgesiv+0) ==========
Dump of memory from 0x080CA3B4 to 0x080CA3E4
80CA3B0          080CA3E4 004025C4 08AD8E90      [.....%@.....]
80CA3C0 07FB1F60 00003B38 00000000 080CA3F0  [`...8;..........]
80CA3D0 00003B38 00000000 080CA3F0 07FA99D4  [8;..............]
80CA3E0 08C91814                             [....]            
========== FRAME [7] (__VInfreq__kkotap+28190 -> _ksesic0+0) ==========
Dump of memory from 0x080CA3E4 to 0x080CA774
80CA3E0          080CA774 02FB2DEB 00003B38      [t....-..8;..]
80CA3F0 00000000 07FA0038 08CD7FFC 000017F8  [....8...........]
80CA400 00000000 000000FF 00000000 07FA00B8  [................]
80CA410 07FA00AC 00000000 07FA00AC 00000000  [................]
80CA420 00000000 080CA474 603BC5F8 08AD8E90  [....t.....;`....]
80CA430 00000000 07FA0038 00002010 603C5AC5  [....8.... ...Z<`]
80CA440 30372B4C 00000002 30372BB8 00003BF0  [L+70.....+70.;..]
80CA450 30372BB8 00000002 30372B4C 080CA3B0  [.+70....L+70....]
80CA460 00002000 0000009E 00000008 329444E8  [. ...........D.2]
80CA470 080CA4F8

Answer 3

哪位高手 加一下我QQ 21095807  我发日志和trc文件 这里附件没发上去，

Answer 4

你贴报错那部分的告警日志。trace文件看不出来。

Answer 5

ora-600多数都是bug导致的。
你的是什么版本的oracle?什么平台?
如果是10g，解决办法有三个:
1。设置optimizer_features_enable=9.2.0
或者
2.打上oracle的补丁patch 5694466 ;
或者
3。在你的view sql语句中添加hint： NO_UNNEST 

Answer 6

你不会是做了DML操作，用了GROUP BY？