DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, July 11, 2017

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


Error:
=====
When we connect the database in the toad we are getting the error.
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

No comments: