My Oracle Support Banner

SQL with _replace_virtual_columns=false and Semi JOIN = ORA-600[rwoirw: Check Ret Val] (Doc ID 2498349.1)

Last updated on FEBRUARY 15, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

SQL with _replace_virtual_columns=false and semi join fails with the following error:

ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []

 

The associated incident trace file shows:

SELECT
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPT_PARAM('_replace_virtual_columns' 'false')
OUTLINE_LEAF(@SEL$1)
LEADING(@SEL$1 T1@SEL$1 T2@SEL$1 T3@SEL$1)
PARTIAL_JOIN(@SEL$1 T3@SEL$1)
END_OUTLINE_DATA
*/
DISTINCT T3.C5,T1.C1
FROM T1 ,T2 ,T3
WHERE T1.C1 = T2.C1
AND T1.C2 = T1.C2
AND T1.C1 = T3.C3
AND T1.C2 = T3.C1
AND T1.C3 = T3.C2
AND T1.C4 = T3.C5
order by T1.C1 asc;

along with the Plan Table:

---------------------------------------------------------------
| Id | Operation                | Name  | Rows | Bytes | Cost |
---------------------------------------------------------------
|  0 | SELECT STATEMENT         |        |   1 |   117 |    9 |
|  1 | SORT UNIQUE              |        |   1 |   117 |    7 |
|* 2 | HASH JOIN SEMI           |        |   1 |   117 |    5 |
|* 3 | HASH JOIN                |        |   3 |   195 |    3 |
|* 4 | INDEX FULL SCAN          | T1_IDX |   4 |   208 |      |
|  5 | TABLE ACCESS FULL        | T2     |  82 |  1066 |    1 |
|  6 | TABLE ACCESS FULL        | T3     |  82 |  4264 |    1 |
---------------------------------------------------------------

 

The Call Stack Trace in the same incident trace file shows:

skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp
 <- ssexhd <- sighandler <- kkqjpdcvp <- kkqjpdcvvpd <- kkqjfChkBasicValidi
  <- kkqctCheckTransVali <- kkqctcvqb <- kkqctcvqb <- kkqctcvqb <- kkqctcvqb
   <- kkqctcvqb <- kkqctcvqb <- kkqctcvqb <- kkqctcvqb <- kkqctcvqb
    <- kkqctcvqb <- kkqctcvqb <- kkqctcvqb <- kkqctcvct <- kkqctChkCBQTvalid
     <- kkqdrv <- opiSem <- opiprs <- kksParseChildCursor <- rpiswu2
      <- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor
       <- opiosq0 <- kpooprx <- kpoal8 <- opiodr <- ttcpip
        <- opitsk <- opiino <- opiodr <- opidrv <- sou2o
         <- opimai_real <- ssthrdmain <- main <- start

This indicates that the error occurred while performing sort processing.

 

Changes

 

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
Changes
Cause
Solution
References


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