High Cpu Usage By M000 Process And Kewrafc Code 5 In MMON Trace File (Doc ID 555124.1)

Last updated on OCTOBER 07, 2015

Applies to:

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

Symptoms

M000 process using nearly 100% CPU. MMON trace reporting following message every minute:

KEWRAFC: Flush slave failed, return Code: 5

The errorstack of the M000 process shows the following DML query being executed: -

insert into wrh$_latch (snap_id, dbid, instance_number, latch_hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time) select :snap_id, :dbid, :instance_number, hash, level#, gets, misses, sleeps, immediate_gets, immediate_misses, spin_gets, sleep1, sleep2, sleep3, sleep4, wait_time from v$latch order by hash

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