ORA-600 [keswxReadGlobalInfoFromStream:magic] (Doc ID 1560406.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

Alert log reports

ORA-00600: internal error code, arguments: [keswxReadGlobalInfoFromStream:magic], [], [], [], [], []


The trace file shows the following information:

----- Current SQL Statement for this session (sql_id=9kddcyq74sg9m) -----
SELECT XMLELEMENT( "sql_monitor_list_report", XMLATTRIBUTES( :B24 AS "version", TO_CHAR(:B17 , :B20 ) AS "sysdate", :B23 AS "auto_refresh", :B22 AS "base_path"),

...
FROM GV$SQL_MONITOR
...
GROUP BY MO2.SQL_ID, MO2.SQL_EXEC_START, MO2.SQL_EXEC_ID ) MO_PX WHERE MO_QC.SQL_ID = MO_PX.SQL_ID(+) AND MO_QC.SQL_EXEC_START = MO_PX.SQL_EXEC_START(+) AND MO_QC.SQL_EXEC_ID = MO_PX.SQL_EXEC_ID(+)) MO


----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
aae082ec0     14960  package body SYS.DBMS_SQLTUNE
aae082ec0     15596  package body SYS.DBMS_SQLTUNE
a9683b188         1  anonymous block


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


... keswxReadGlobalInfoFromStream  keswxFixMakeRow  keswxFixMonCbk  qerfxFetch  qerflFetch  qervwFetch  rwsfcd  qerlbFetch  qerhjFetch  qergsFetch ...

 
The process state in the trace file shows the session is from the Enterprise Manager (program: OMS)

...
PROCESS STATE
-------------
...
   SO: 0xad92741b0, type: 4, owner: 0xad8c848d0, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
    proc=0xad8c848d0, name=session, file=ksu.h LINE:12624 ID:, pg=0
   (session) sid: 1211 ser: 52677 trans: 0x0, creator: 0xad8c848d0
             flags: (0x8000041) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
             flags2: (0x40009) -/-/INC
             DID: , short-term DID:
             txn branch: 0x0
             oct: 3, prv: 0, sql: 0xa6c99c598, psql: 0xaad32bde8, user: 0/SYS
   ksuxds FALSE at location: 0
   service name: SYS$USERS
   client details:
     O/S info: user: oracle, term: unknown, ospid: 1234
     machine: wcs01 program: OMS
     application name: Admin Connection, hash value=3342475503
   Current Wait Stack:
     Not in wait; last wait ended 4.971778 sec ago
   ...

 

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