ORA-00600: internal error code, arguments: [kkocxj : pjpCtx], [], [], [], [], [], [], []

Symptoms

ORA-00600 [kkocxj : pjpCtx] error is reported when running a complex query.

Cause

Bug 7014646: INTERNAL ERROR CODE, ARGUMENTS: [KKOCXJ : PJPCTX], [], [], [], [], []

Call stack includes:

kkocxj <- kkoiqb <- kkooqb <- kkoqbc <- apakkoqb <- apaqbdDescendents <- apaqbdListReverse
   <- apaqbd <- kkqctCostTransfQB <- kkqctdrvJP <- kkqjpdttr <- kkqjpdttr <- kkqctdrvTD <- kkqjpddrv
      <- kkqdrv <- kkqctdrvIT <- apadrv <- opitca <- kksFullTypeCheck <- rpiswu2 <- kksLoadChild
         <- kxsGetRuntimeLock <- kksfbc <- kkspbd0 <- kksParseCursor <- opiosq0 <- opipls <- opiodr
            <- rpidrus <- skgmstack <- rpidru <- rpiswu2 <- rpidrv <- psddr0 <- psdnal

If a PUSH_PRED hint containing a predicate number is present in the culprit query, then this could be Bug 5637915.

Solution

Bug 7014646 is fixed in 10.2.0.5 , 11.1.0.7 and 11.2.0.1

For earlier DB versions, please apply Patch 7014646 where available
OR
use the following workaround:

SQL> conn / as sysdba
SQL> alter system set "_optimizer_push_pred_cost_based"=false;
SQL> exit

References

BUG:7014646 - ORA-600: INTERNAL ERROR CODE, ARGUMENTS: [KKOCXJ : PJPCTX], [], [], [], [], []

ITPub博客

ORA-00600: [kkocxj : pjpCtx]

Symptoms

Cause

Solution

References

最新文章