Oracle Database Error: ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [65562], [26], [1144616], [1], [], [], [], [], [], [], []

SQL> exec DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO;
BEGIN DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO; END;

*
ERROR at line 1:
ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch],
[65562], [26], [1144616], [1], [], [], [], [], [], [], []
ORA-06512: at “SYS.DBMS_STATS”, line 2141
ORA-06512: at “SYS.DBMS_STATS”, line 43486
ORA-06512: at line 1

DDE: Problem Key ‘ORA 600 [qosdExpStatRead: expcnt mismatch]’ was flood controlled (0x4) (incident: 2017148)
ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [65562], [26], [1144616], [1], [], [], [], [], [], [], []
2025-07-29T11:33:58.617971+03:00
Incident 2017643 created, dump file: /oraclex/oradbp25/diag/rdbms/oradbp25/oradbp25/incident/incdir_2017643/oradbp25_dw00_3988067_i2017643.trc
ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [65562], [26], [1144616], [1], [], [], [], [], [], [], []
ORA-06512: at “SYS.DBMS_STATS”, line 2141
ORA-06512: at “SYS.DBMS_STATS”, line 57633
ORA-06512: at “SYS.DBMS_STATS”, line 57866
ORA-06512: at “SYS.KUPW$WORKER”, line 30029
ORA-06512: at “SYS.KUPW$WORKER”, line 3503
ORA-06512: at “SYS.KUPW$WORKER”, line 13746
ORA-06512: at “SYS.KUPW$WORKER”, line 2439
ORA-06512: at line 2

SOLUTION/FIX:

SQL> alter system set “_fix_control”=’31143146:on’,’32005394:on’ scope=both;

of course, its highly recommended to open a case with ORACLE.

Oracle 19c – Oracle Spatial Bug ORA-13199

I have recently upgraded a database to Oracle 19c with latest patches applied (APRIL 2020) 19.7.0.0.200414  ….as you know by now Oracle 19c is the long-term release.

After editing and committing the SQL transaction on an Oracle Spatial Table using ESRI ArcGIS Desktop Applicaiton….the following errors were thrown to the end-user:

ORA-03114: not connected to ORACLE

ORA-00603: Oracle server session terminated

ORA-00600: internal error code arguments[6006],[1],[]

ORA-13199: Spatila index commit Failure

Process ID: 90662
Session ID: 392 serial number: 27690

Solution:

This is a bug and you will need to download and apply the patch from Oracle Support.

Patch 29789911: ORA-13199: SPATIAL COMMIT FAILURE

*** Updated August 6 2020: The patch 29789911 is already included in 19.8 RU so there is no need to apply one-off-patch just apply latest RU