ORA-7445: [KSLTBL()+820] At Insert Into WRH$_LATCH (Doc ID 1081014.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

The following error is reported in the alert log during insert into wrh$_latch:

ORA-7445: EXCEPTION ENCOUNTERED: CORE DUMP [KSLTBL()+820] [SIGSEGV]



Stack trace is similar to:

ksltbl qerfxFetch qersoFetch rwsfcd qerltcFetch insexe



Current SQL is an INSERT into wrh$_latch:

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