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
  • July 11, 2017 | 24 views
  • Comments