Last updated on OCTOBER 04, 2015

Applies to:

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


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 ...
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 


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