偶遇ora-0600

数据库版本oracle1024
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kkqcbydrv:1], [], [], [], [], [], [], []
Current SQL statement for this session:
SELECT BND.PRDT_ID,
       BND.PRDT_ID as sprdt_id,
       BND.PRDT_NAME,
       bnd.TRADINGCODE,
       to_char(BD.FULLCLOSINGPRICE,'fm9999999999999999990.0000') as FULLCLOSINGPRICE,
       to_char(BD.FULLDAYCHANGERATE,'fm9999999999999999990.00') as FULLDAYCHANGERATE,
       to_char(nvl(BD.NETCLOSINGPRICE,0),'fm9999999999999999990.0000') as NETCLOSINGPRICE,
       to_char(nvl(BD.NETDAYCHANGERATE,0),'fm9999999999999999990.00')  as NETDAYCHANGERATE,
       BND.EXCHANGECODE
  FROM (SELECT SECUCODE, TRADINGCODE, EXCHANGECODE, PRDT_ID, PRDT_NAME
          FROM (SELECT BB.SECUCODE,
                       BB.TRADINGCODE,
                       BB.EXCHANGECODE,
                       A.PRDT_ID,
                       A.PRDT_NAME,
                       ROW_NUMBER() OVER(PARTITION BY BB.TRADINGCODE ORDER BY BB.SECUABBR) AS RN
                  FROM ODS_OCRM_DX_PRDT_FOR_INFO A
                  JOIN ODS_OCRM_PRDT_CATA_FOR_INFO B
                    ON A.PRDT_ID = B.PRDT_ID
                    AND B.PRDT_TYPE_ID IN (select prdt_type_id from ods_ocrm_prdt_type_rela_info t
connect by prior t.prdt_type_id = t.up_prdt_type_id
 start with t.prdt_type_id = 'XE030000')
                 
                  LEFT JOIN BND_BASICINFO BB
                    ON BB.EXCHANGECODE != '113'
                   AND BB.TRADINGCODE = A.PRDT_ID)
         ) BND,
       BND_DAILYQUOTE BD
 WHERE BND.SECUCODE = BD.SECUCODE
   AND BD.TRADINGDAY = (SELECT MAX(BD1.TRADINGDAY)
                          FROM BND_DAILYQUOTE BD1
                         WHERE BND.SECUCODE = BD1.SECUCODE)
 ORDER BY FULLDAYCHANGERATE DESC, NETDAYCHANGERATE DESC
----- Call Stack Trace -----
calling              call     entry                argument values in hex     
location             type     point                (? means dubious value)    
-------------------- -------- -------------------- ----------------------------
ksedst()+31          call     ksedst1()            000000000 ? 000000001 ?
                                                   7FFF10FC3660 ? 7FFF10FC36C0 ?
                                                   7FFF10FC3600 ? 000000000 ?
ksedmp()+610         call     ksedst()             000000000 ? 000000001 ?
                                                   7FFF10FC3660 ? 7FFF10FC36C0 ?
                                                   7FFF10FC3600 ? 000000000 ?
ksfdmp()+21          call     ksedmp()             000000003 ? 000000001 ?
                                                   7FFF10FC3660 ? 7FFF10FC36C0 ?
                                                   7FFF10FC3600 ? 000000000 ?
kgerinv()+161        call     ksfdmp()             000000003 ? 000000001 ?
                                                   7FFF10FC3660 ? 7FFF10FC36C0 ?
                                                   7FFF10FC3600 ? 000000000 ?
kgeasnmierr()+163    call     kgerinv()            0068966E0 ? 2B0C98090040 ?
                                                   7FFF10FC36C0 ? 7FFF10FC3600 ?
                                                   000000000 ? 000000000 ?
kkqcbydrv()+317      call     kgeasnmierr()        0068966E0 ? 2B0C98090040 ?
                                                   7FFF10FC36C0 ? 7FFF10FC3600 ?
                                                   000000000 ? 000000000 ?
qksqbApplyToQbcLoc(  call     kkqcbydrv()          2B0C983BC618 ? 7FFF10FC4AA8 ?
--More--(0%)


修改隐含参数

ALTER system  SET "_optimizer_connect_by_cost_based" = FALSE;