ORA-600 [kssocbg] Using PQ Statement Queueing (Doc ID 2022336.1)

Last updated on MAY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Using PQ statement queueing, ORA-600 errors can be raised with next specifics:

The alert log may show both next errors:

ORA-00600: internal error code, arguments: [kssocbg], [], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [794], [0xFCD3F6338], [0xFBE3BB508], [0xFDF0B2618], [4294967295], [], [], [], [], [], [], []

 
The trace file information for the ORA-600 [kssocbg] shows:

============
Plan Table
============
+------------------------------------------------+---------------------------------------+-------------+
| Id | Operation           | Name         | Rows | Bytes | Cost | Time     | TQ   |IN-OUT|PQ Distrib   |
-----------------------------------------------------+-----------------------------------+-------------+
|  0 | SELECT STATEMENT    |              |      |       |    2 |          |      |      |             |
|  1 | PX COORDINATOR      |              |      |       |      |          |      |      |             |
|  2 | PX SEND QC (RANDOM) | :TQ10000     |    1 |    63 |    2 | 00:06:48 |:Q1000| P->S |QC (RANDOM)  |
|  3 | PX BLOCK ITERATOR   |              |    1 |    63 |    2 | 00:06:48 |:Q1000| PCWC |             |
|  4 | TABLE ACCESS FULL   | Test_table   |    1 |    63 |    2 | 00:06:48 |:Q1000| PCWP |             |
+------------------------------------------------+---------------------------------------+-------------+


Error: ORA-600 [kssocbg] [] [] [] [] [] [] [] [] [] [] []
[00]: dbgexExplicitEndInc [diag_dde]
[01]: dbgeEndDDEInvocationImpl [diag_dde]
[02]: dbgeEndDDEInvocation [diag_dde]
[03]: kssocbg [VOS]<-- Signaling
[04]: ksmdget [KSM]
[05]: kssadpm [VOS]
[06]: kxfxqsoc [PX_Queuing]
[07]: kxfxqOnOrderQueue [PX_Queuing]


The trace file information for the ORA-600 [794] shows:

Error: ORA-600 [794] [0xFCD3F6338] [0xFBE3BB508] [0xFDF0B2618] [4294967295] [] [] [] [] [] [] []
[00]: dbgexProcessError [diag_dde]
[01]: dbgeExecuteForError [diag_dde]
[02]: dbgePostErrorKGE [diag_dde]
[03]: dbkePostKGE_kgsf [rdbms_dde]
[04]: kgeade []
[05]: kgeriv_int []
[06]: kgeriv []
[07]: kgeasi []
[08]: ksmdget [KSM]<-- Signaling
[09]: kssadpm [VOS]
[10]: kxfxqsoc [PX_Queuing]
[11]: kxfxqOnOrderQueue [PX_Queuing]
[12]: opiexe []

 

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