7445[Lxklikefast] From Select Sql Using The LIKE Operator
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 18.104.22.168 to 22.214.171.124
This problem can occur on any platform.
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms