ORA-00600[QSMEMDNF_MODIFIED_DNF] REPORTED IN ALERT.LOG (Doc ID 889649.1)

Last updated on OCTOBER 04, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.1.0 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

ORA-00600: internal error code, arguments: [qsmemdnf_modified_dnf] reported in alert.log and trace files generated with following error stack.

Reported on query using query rewrite with multiple AND and ORs (even implicit like IN clause).

Sample of Trace file:

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [qsmemdnf_modified_dnf], [], [], [], [], [], [], []
Current SQL statement for this session:
select * from Medicoes_Eletr where Dat_Mdc >= :1 and
Dat_Mdc < :2 and (DW_Ponto_Medicao = :3 or DW_Ponto_Medicao = :4 or DW_Ponto_Medicao = :5)
and ((dat_mdc < to_date('02/09/2009','dd/mm/yyyy') or (dat_mdc =
to_date('02/09/2009','dd/mm/yyyy') AND hora_mdc < 225500))or (dat_Mdc >
to_date('03/09/2009','dd/mm/yyyy')or (dat_Mdc = to_date('03/09/2009','dd/mm/yyyy') AND ...
...
 AND
hora_mdc > 200500)))and ((dat_mdc < to_date('03/04/2008','dd/mm/yyyy') or (dat_mdc =
to_date('03/04/2008','dd/mm/yyyy') AND hora_mdc < 10000))or (dat_Mdc >
to_date('04/04/2008','dd/mm/yyyy')or (dat_Mdc = to_date('04/04/2008','dd/mm/yyyy') AND
hora_mdc > 203000)))
and (DW_Ponto_Medicao = :8 or DW_Ponto_Medicao = :9 or DW_Ponto_Medicao = :10))

 

----- Call Stack Trace -----  
ksedst ksedmp ksfdmp kgerinv kgeasnmierr qsmemdnf_modified_d qsmenst_normalize_s electiontree qsmenopt_normalize_ optpredtree kkpapnBuildList kkpapDAFkkSLvl kkpapDAFkk kkofmp kkoiqb kkooqb kkoqbc apakkoqb apaqbd apaqbd apadrv opitca kksSetBindType kksfbc 
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms