还是bug

接到通知，说报表数据库报错：

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

Current SQL statement for this session:

INSERT INTO ACTIVE_USER_WAP_H(MOBILENUM,LOCATIONID,SUBSCAT,STARTTIME,COUNTS)

      SELECT MOBILENUM,LOCATIONID,SUBSCAT,TRUNC(STARTTIME,'HH24'),COUNT(*)

      FROM ACTIVE_USER_WAP

      WHERE FLOW_TIME<:b1

      GROUP BY MOBILENUM,LOCATIONID,SUBSCAT,TRUNC(STARTTIME,'HH24')

----- PL/SQL Call Stack -----

  object      line  object

  handle    number  name

c000000085626108        51  function REPORT.WAP_ACTIVE_USER_STAT

c00000008b7733d8         3  anonymous block

----- Call Stack Trace -----

 

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

 

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

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

System altered.

SQL>