My Oracle Support Banner

Use Of Timestamp Operator May Lead To ORA-600 [17059] (Doc ID 784892.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.1.0.6 - Release: 11.1 to 11.1
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 11.1 to 11.1

Symptoms

The following symptoms were reported for this issue :-

a) Alert reports errors similar to :-

Errors in file /xxxx//xxxx_ora_6574.trc
(incident=220772):
ORA-00600: Interner Fehlercode, Argumente: [17059], [0x1BDB9C8C0],
[0x1BDB9CBE8], [0x17E018DE8], [], [], [], []

b) Instance parameter cursor_sharing is set to FORCE

c) SQL is using TIMESTAMP operator e.g. :-

LIBRARY HANDLE:0x17e018de8 bid=77465 hid=226d2e99 lmd=N pmd=0 sta=VALD
name=insert into Log values (:"SYS_B_0",:"SYS_B_1",:"SYS_B_2",:"SYS_B_3",
timestamp:"SYS_B_4",:"SYS_B_5",:"SYS_B_6",:"SYS_B_7",:"SYS_B_8",:"SYS_B_9",
NULL,NULL)
.
LOCK OWNERS:
lock user session count mode flags
-------- -------- -------- ----- ---- ------------------------
1d7499d80 1d0b8d040 1d0b8d040 2 N CNB/[01]
LIBRARY OBJECT: 0x1bdb9c8c0
flg=EXS[0001] pfl=[0000] ssta=VALD load=0
CHILDREN: size=32768
child# table reference handle
------ -------- --------- --------
0 1bdeda180 1bded9e10 17e440678
.
. ----> other entries here
.
32767 1474d7670 146192330 17fab46a8
LIBRARY HANDLE:0x17e440678 bid=0 hid=0 lmd=0 pmd=0 sta=VALD
.
So max number of child cursors are reached and hence the 600[17059]

e) Stack trace will be similar to :-

Function List (to Full stack) (to Summary stack)
skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp
<- ksfdmp <- dbgexPhaseII <- dbgexProcessError <- dbgeExecuteForError
<- dbgePostErrorKGE
<- dbkePostKGE_kgsf <- kgeriv <- kgesiv <- kgesic3
<- kgltba <- kglhdgc <- kglget <- kxsGetLookupLock
<- kksfbc <- kkspsc0 <- kksParseCursor <- opiosq0 <- kpooprx
<- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino
<- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain
<- main <- libc_start_main <- start

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.