SQL - Como localizar e corrigir registros de DML com erro por estarem duplicados?

RTREPLICATOR.FAQ-8359

Como consultar dml-logs com erro por estarem duiplicados:

select e.*
from dml_logs e
where queue = 'E'
and exists (
select *
from dml_logs o
where o.dml = e.dml
and o.dml_parameters = e.dml_parameters
and o.origin_table_name = e.origin_table_name
and o.origin_record_id = e.origin_record_id
)

Como excluir dmls duplicados

delete from dml_logs where id in 
(
  select e.id
  from dml_logs e
  where queue = 'E'
  and exists (
    select *
    from dml_logs o
    where o.dml = e.dml
    and o.dml_parameters = e.dml_parameters
    and o.origin_table_name = e.origin_table_name
    and o.origin_record_id = e.origin_record_id
  )
)