ORA-00600: internal error code, arguments: [15851], [8], [8], [1], [2], [], [], []

最新推荐文章于 2019-10-28 21:10:44 发布

1ihj2015

最新推荐文章于 2019-10-28 21:10:44 发布

阅读量1.2k

点赞数

分类专栏： Study & Testing

本文链接：https://blog.csdn.net/itdba/article/details/38402697

版权

Study & Testing 专栏收录该内容

66 篇文章 0 订阅

订阅专栏

============
Plan Table
============
------------------------------------------------------------+-----------------------------------+-------------------------+---------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time | TQ |IN-OUT|PQ Distrib | Pstart| Pstop |
------------------------------------------------------------+-----------------------------------+-------------------------+---------------+
| 0 | CREATE INDEX STATEMENT | | | | 728K | | | | | | |
| 1 | PX COORDINATOR | | | | | | | | | | |
| 2 | PX SEND QC (ORDER) | :TQ10001 | 507M | 13G | | |:Q1001| P->S |QC (ORDER) | | |
| 3 | INDEX BUILD NON UNIQUE | NMVJH_HIS | | | | |:Q1001| PCWP | | | |
| 4 | SORT CREATE INDEX | | 507M | 13G | | |:Q1001| PCWP | | | |
| 5 | PX RECEIVE | | 507M | 13G | 582K | 02:59:08 |:Q1001| PCWP | | | |
| 6 | PX SEND RANGE | :TQ10000 | 507M | 13G | 582K | 02:59:08 |:Q1000| P->P |RANGE | | |
| 7 | PX BLOCK ITERATOR | | 507M | 13G | 582K | 02:59:08 |:Q1000| PCWC | | 1 | 2 |

| 8 | TABLE ACCESS FULL | TB_FLIGHT_DETAIL_RO2_HIS| 507M | 13G | 582K | 02:59:08 |:Q1000| PCWP | | 1 | 26 |

Content of other_xml column
===========================
db_version : 10.2.0.4
parse_schema : SZADMIN
plan_hash : 3720678518
index_size : 22682796032

经查证，这个错误是有一个负责的语句引起的，该语句中含有的group by触发了这个bug，详情请参考：Bug 2012482

解决方法是设置参数"_gby_onekey_enabled" 为 FALSE

SQL> alter system set "_gby_onekey_enabled"=false scope=spfile;

System altered.

SQL>

----------------------------------------------------------+-----------------------------------+---------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time | Pstart| Pstop |
----------------------------------------------------------+-----------------------------------+---------------+
| 0 | CREATE INDEX STATEMENT | | | | 2925K | | | |
| 1 | INDEX BUILD UNIQUE | RO_HIS | | | | | | |
| 2 | SORT CREATE INDEX | | 507M | 21G | | | | |
| 3 | PARTITION RANGE ALL | | 507M | 21G | 2100K | 07:10:05 | 1 | 13 |
| 4 | PARTITION LIST ALL | | 507M | 21G | 2100K | 07:10:05 | 1 | 2 |
| 5 | TABLE ACCESS FULL | TB_FLIGHT_DETAIL_RO2_HIS| 507M | 21G | 2100K | 07:10:05 | 1 | 26 |
----------------------------------------------------------+-----------------------------------+---------------+

One workaround described in bug 396720 is to set  
 
    event = "10805 trace name context forever, level 1" 
 
This event turns off big sort keys.  However, setting this event may not be 
advisable as it may cause performance problems for other queries.