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 22, 2019

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:

-- The parallel query returns 0 rows with FGAC applied.


   SQL> SELECT /*+ PARALLEL(MAP,32) */ COUNT(*)
        FROM   T1,
               T2
        WHERE  t1.col2 IN (xx)
        AND    T1.col1 = T2.col1;
    
      COUNT(*)
    ----------
             0
    
    1 row selected.


-- The same parallel query returns expected results if FGAC removed.

SQL> SELECT /*+ PARALLEL(MAP,32) */ COUNT(*)
FROM T1,
T2
WHERE t1.col2 IN (xx)
AND T1.col1 = T2.col1;
    
      COUNT(*)
    ----------
            11
    
    1 row selected.


-- By keeping FGAC applied, the query works fine serially without parallel hint
 SQL> SELECT /*+ PARALLEL(MAP,32) */ COUNT(*)
FROM T1,
T2
WHERE t1.col2 IN (xx)
AND T1.col1 = T2.col1;
    
      COUNT(*)
    ----------
            11
    
    1 row selected.

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.