ORA-600 [15818] Using PX (Parallel Execution) (Doc ID 1622312.1)

Last updated on MARCH 18, 2014

Applies to:

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

Symptoms

Alert log shows following error:

Thu Jan 02 16:39:16 2014
Archived Log entry 613631 added for thread 1 sequence 62980 ID 0x8c05c8ad dest 1:
Thu Jan 02 17:03:58 2014
Errors in file /u01/app/oracle/diag/rdbms/pgardwv2/pgardwv21/trace/pgardwv21_ora_19208.trc (incident=2211073):
ORA-00600: internal error code, arguments: [15818], [666], [0], [65], [2], [0], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/pgardwv2/pgardwv21/incident/incdir_2211073/pgardwv21_ora_19208_i2211073.trc
Thu Jan 02 17:07:33 2014
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Thu Jan 02 17:07:34 2014
Dumping diagnostic data in directory=[cdmp_20140102170734], requested by (instance=1, osid=19208), summary=[incident=2211073].


Trace files shows a current sql, call stack and plan table like:

*** 2014-01-02 17:03:58.333
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)

----- Current SQL Statement for this session (sql_id=fd2sjgpvzxspq) -----
insert /*+ append */ into PGARYSRSTG.TST_0137_MV200AS_7  (column_num, row_id, explanation_text, main_group_code, group_code_1, group_code_2, group_code_3,   period_end_date, version_num, working_seq, report_row_num, sum_tl_balance_amnt, round_tl_balance_amnt) select t1.column_num, t1.row_id, t2.explanation_text, t2.main_group_code, t2.group_code_1, t2.group_code_2, t2.group_code_3, t1.period_end_date, t1.version_num, t1.working_seq,             t2.report_row_num, sum(sum_tl_balance_amnt) sum_tl_balance_amnt, round(sum(round_tl_balance_amnt)/1000) round_tl_balance_amnt from PGARYSRSTG.tst_0137_mv200as_6 t1, PGARYSR.tpr_main_explanation t2 where t1.row_id = t2.row_id and t2.report_code = '0137-MV200AS' group by t1.column_num, t1.row_id, t2.explanation_text, t2.main_group_code, t2.group_code_1, t2.group_code_2, t2.group_code_3, t1.period_end_date, t1.version_num, t1.working_seq, t2.report_row_num union all select     column_num, row_id, explanation_text, main_group_code, group_code_1, group_code_2, group_code_3, period_end_date, version_num, working_seq, report_row_num,    sum_tl_balance_amnt, round_tl_balance_amnt from PGARYSRSTG.tst_0137_mv200as_5 where not (row_id in (100, 110,  210, 220) and column_num in (2,3,4,5,6,7))  order by 1,2

----- Call Stack Trace -----

     skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp
       <- ksfdmp <- dbgexPhaseII <- dbgexProcessError <- dbgeExecuteForError <- dbgePostErrorKGE
        <- 2138 <- dbkePostKGE_kgsf <- kgeade <- kgeriv_int <- kgeriv
         <- kgeasi <- kxfqenq <- qertqoRop <- kdstf11001010001km <- kdsttgr
          <- qertbFetch <- rwsfcd <- qertqoFetch <- qerpx_resume <- qerpxFetch
           <- insdlexe <- insExecStmtExecIniE <- ngine <- insexe <- ngine
            <- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk
             <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
              <- ssthrdmain <- main <- libc_start_main <- start

Plan Table
============
------------------------------------------------------------------+-----------------------------------+-------------------------+
| Id  | Operation                           | Name                | Rows  | Bytes | Cost  | Time      |  TQ  |IN-OUT|PQ Distrib |
------------------------------------------------------------------+-----------------------------------+-------------------------+
| 0   | INSERT STATEMENT                    |                     |       |       |  1196 |           |      |      |           |
| 1   |  PX COORDINATOR                     |                     |       |       |       |           |      |      |           |
| 2   |   PX SEND QC (RANDOM)               | :TQ10003            |       |       |       |           |:Q1003| P->S |QC (RANDOM)|
| 3   |    LOAD AS SELECT                   |                     |       |       |       |           |:Q1003| PCWP |           |
| 4   |     UNION-ALL                       |                     |       |       |       |           |:Q1003| PCWP |           |
| 5   |      HASH GROUP BY                  |                     |     1 |   102 |   951 |  00:00:08 |:Q1003| PCWP |           |
| 6   |       HASH JOIN                     |                     |    56 |  5712 |   950 |  00:00:08 |:Q1003| PCWP |           |
| 7   |        BUFFER SORT                  |                     |       |       |       |           |:Q1003| PCWC |           |
| 8   |         PX RECEIVE                  |                     |    29 |  2030 |   706 |  00:00:06 |:Q1003| PCWP |           |
| 9   |          PX SEND RANGE              | :TQ10000            |    29 |  2030 |   706 |  00:00:06 |      | S->P |RANGE      |
| 10  |           TABLE ACCESS STORAGE FULL | TPR_MAIN_EXPLANATION|    29 |  2030 |   706 |  00:00:06 |      |      |           |
| 11  |        PX RECEIVE                   |                     |   247 |  7904 |   244 |  00:00:02 |:Q1003| PCWP |           |
| 12  |         PX SEND RANGE               | :TQ10001            |   247 |  7904 |   244 |  00:00:02 |:Q1001| P->P |RANGE      |
| 13  |          PX BLOCK ITERATOR          |                     |   247 |  7904 |   244 |  00:00:02 |:Q1001| PCWC |           |
| 14  |           TABLE ACCESS STORAGE FULL | TST_0137_MV200AS_6  |   247 |  7904 |   244 |  00:00:02 |:Q1001| PCWP |           |
| 15  |      SORT ORDER BY                  |                     |    68 |  5032 |   245 |  00:00:02 |:Q1003| PCWP |           |
| 16  |       PX RECEIVE                    |                     |    68 |  5032 |   244 |  00:00:02 |:Q1003| PCWP |           |
| 17  |        PX SEND RANGE                | :TQ10002            |    68 |  5032 |   244 |  00:00:02 |:Q1002| P->P |RANGE      |
| 18  |         PX BLOCK ITERATOR           |                     |    68 |  5032 |   244 |  00:00:02 |:Q1002| PCWC |           |
| 19  |          TABLE ACCESS STORAGE FULL  | TST_0137_MV200AS_5  |    68 |  5032 |   244 |  00:00:02 |:Q1002| PCWP |           |
------------------------------------------------------------------+-----------------------------------+-------------------------+

 

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