7445[Lxklikefast] From Select Sql Using The LIKE Operator (Doc ID 400179.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 9.2.0.5
This problem can occur on any platform.

Symptoms

All of the following symptoms will be observed

a) Trace file will show failing SQL statement using a LIKE operator
b) SQL will work if this is omitted
c) ORA-07445 will be repoted in alert log and trace will be written into UDUMP
d) Stack from trace will be similar to :-

Function List (to Full stack) (to Summary stack)
ksedmp ssexhd sigacthandler lxkLikeFast lxkLikeSB lxkLike evalik expeal
qertbFetchByRowID rwsfcd qerflFetchOutside rwsfcd qeruaFetch qervwFetch
opifch2 opiall0 kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o
main start

e) The address reported is immediately after the end of the source buffer.

The final symptom can be confirmed by ORACLE Support if needed but if (a)-(d) are observed and the stack shows
lxkLikeFast next to lxkLikeSB it is advised to use this article as the first step.

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