ORA 600 [kglhpd-bad-free] And High Waits For "cursor: pin S wait on X"

Last updated on FEBRUARY 07, 2014

Applies to:

Symptoms

1. A SELECT statement fails with:
   
   ORA-00600: internal error code, arguments: [kglhpd-bad-free], [0x44DFFC210], [], [], [], [], [], [], [], [], [], []
   
   
   
2. Review of the generated tracefiles reveals a call stack similar to:
   
   kglhpd_internal <- kghfrunp <- kghfnd <- kghalo <- kghgex <- kghalf <- kglHeapInitializeIn <- ternal <- kglobpn <- ternal <- kglpim <- kglpin <- kkspsc0
   <- kksParseCursor <- opiosq0 <- kpooprx <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main

Changes

SQL plan baselines are enabled.

Cause