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

Last updated on NOVEMBER 28, 2016

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms