ORA-00600 [15815] Running A Query With Order By DBMS_RANDOM.RANDOM (Doc ID 781668.1)

Last updated on MARCH 02, 2009

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6.0
This problem can occur on any platform.

Symptoms

o Running a query with order by dbms_random.random fails with following error:

select * from parcel order by dbms_random.random;

ORA-600: internal error code, arguments: [15815], [12], [376], [355], [], [], [], []


o Alert log shows:

ORA-600: internal error code, arguments: [15815], [12], [376], [355], [],
[], [], []


o Call stack trace is similar to:

skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp
<- ksfdmp <- dbgexPhaseII <- dbgexProcessError <- dbgeExecuteForError
<- dbgePostErrorKGE <- dbkePostKGE_kgsf <- kgeade <- kgeriv_int <- kgeriv
<- kgeasi <- kxfqupp <- kxfqira <- qerpxFetch <- opifch2
<- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino

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