Query Raise ORA 7445 [kkqfppMoveSqCB] On Oracle RDBMS 12c (Doc ID 2022274.1)

Last updated on JULY 22, 2015

Applies to:

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

Symptoms

ORA_7445 [kkqfppMoveSqCB()+133] is reported when executing a query over gv$ views:


SELECT blocking_sid, num_blocked
FROM ( SELECT blocking_sid, SUM(num_blocked) num_blocked
FROM ( SELECT l.id1, l.id2,
MAX(DECODE(l.block, 0, i.instance_name||' - Session SID: '||l.sid||' Serial#: '||s.serial#||' - user: '||s.program||' - '||s.username )) blocking_sid,
SUM(DECODE(l.request, 0, 0, 1 )) num_blocked
FROM gv$lock l, gv$instance i, gv$session s
WHERE ( l.block= 0 OR l.request > 0 ) AND
l.inst_id = i.inst_id and
s.sid = l.sid and
s.inst_id=l.inst_id
GROUP BY l.id1, l.id2)
GROUP BY blocking_sid
ORDER BY num_blocked DESC)
WHERE num_blocked != 0
and blocking_sid not in ('1','2')
and (select value from sys.v_$parameter where name='cluster_database')='FALSE'

The call stack in the trace file generated by the error includes the following functions:

 

kkqfppMoveSqCB <- qksopvisitOpns <- qksopVisitOpns <- kqkfppModfilter <-
kkqfppPsh <- kkqfppDrv1 <- kkqfppDrvDescendents <- kkqfppDrv <- kkqfppPsh <-
kqkfppDrv1 <- kkqfppDrvDescendents <- kkqfppDrv <- kkqfppPsh <-
kkqfppDrvDescendents <- kkqfppDrv <- kkqctdrvIT <- apadrv <- opitca <-
kksfullTypeCheck <- rpiswu2 <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <-
kkspsc0 <- kksParseCursor <- opiosq0 <- kpoal8 <- opiodr <- ttcpip <- opitsk
<- opiino <- opiodr <- sou2o

 The query executed without problems in 11.2.0.3 but started to report errors after upgrading to 12.1.0.2.

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