My Oracle Support Banner

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

Last updated on MARCH 18, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.