My Oracle Support Banner

Parallel Query With Virtual Private Database Returns Wrong Result or Fails With ORA-600[kzrtgpp - kxfxslavesql] (Doc ID 755975.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

 

When using both
1. parallel query execution
2. VPD (FGAC) predicates attached to a query.

 

a query can either
1. fail with

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kzrtgpp - kxfxSlaveSQL], [], [], [], [], [], [], []

Errorstack:

kzrtgpp <- kzrtpci <- kglsscn <- kqlsscn <- kkmfcblo
<- kkmpfcbk <- qcsprfro <- qcsprfro_tree <- qcsprfro_tree <- qcspafq
<- qcspqbDescendents <- 3a0 <- qcspqb <- kkmdrv <- opiSem
<- opiDeferredSem <- opitca <- kksFullTypeCheck <- rpiswu2 <- kksLoadChild
<- kxsGetRuntimeLock <- 810 <- kksfbc <- opiexe <- kpoal8
<- opiodr <- kpoodr <- upirtrc <- kpurcsc <- kpuexecv8
<- kpuexec <- OCIStmtExecute <- kxfxsStmtExecute <- kxfxsExecute <- kxfxsp
<- kxfxmai <- kxfprdp <- opirip <- opidrv <- sou2o
<- opimai_real <- main <- start


or
2. yield wrong results.
The issue does not reproduce in 11g.

Example of wrong results situation:

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
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.