ORA-600 [keswxReadGlobalInfoFromStream:magic]
(Doc ID 1560406.1)
Last updated on JANUARY 29, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
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 ...
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
...
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
...
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 |