ORA-07445[QKS3TFINISH] Seen From SQL Query when using STAR_TRANSFORMATION_ENABLED (Doc ID 371028.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

Errors

The following error/combination of errors have been observed within the alert log for this issue:-

a) ORA-07445[QKS3TFINISH]

All of the following symptoms will be observed :-

a) ORA-07445 trace file shows affected SQL SELECT statement
b) STAR_TRANSFORMATION_ENABLED will be set to TRUE or TEMP_DISABLE
c) SQL will work if STAR_TRANSFORMATION_ENABLED=FALSE and will fail otherwise

The stack will be similar to:-
qks3tFinish kkooqb kkoqbc apakkoqb apaqbd apadrv
opitca kkslod kglobld kglobpn kglpim kglpin
kksfbc kkspsc0 opiosq0 kpooprx kpoal8 opiodr
ttcpip opitsk opiino opiodr opidrv sou2o main start

QKS3TFINISH must be present in the stack

d) SQL runs if following workaround is applied:

alter session set events '10162 trace name context forever, level 3';

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