Gathering table stats using DBMS_STATS package intermittently fails with ORA-600 [15709] and ORA-932
(Doc ID 3018499.1)
Last updated on APRIL 23, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.20.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
In RAC environment, intermittently gathering table stats using DBMS_STATS package failing with below errors reported in database alert.log file:
2024-04-06T02:22:45.577884+00:00
Errors in file /u02/app/oracle/diag/rdbms/test/test1/trace/test1_ora_44289.trc (incident=4047120):
ORA-00600: internal error code, arguments: [15709], [29], [1], [2], [2], [P002], [19191], [], [], [], [], []
ORA-12801: error signaled in parallel query server P002, instance test1 (1)
ORA-00932: inconsistent datatypes: expected BLOB from approx_count_distinct_detail got
Incident details in: /u02/app/oracle/diag/rdbms/test/test1/incident/incdir_4047120/test1_ora_44289_i4047120.trc
Errors in file /u02/app/oracle/diag/rdbms/test/test1/trace/test1_ora_44289.trc (incident=4047120):
ORA-00600: internal error code, arguments: [15709], [29], [1], [2], [2], [P002], [19191], [], [], [], [], []
ORA-12801: error signaled in parallel query server P002, instance test1 (1)
ORA-00932: inconsistent datatypes: expected BLOB from approx_count_distinct_detail got
Incident details in: /u02/app/oracle/diag/rdbms/test/test1/incident/incdir_4047120/test1_ora_44289_i4047120.trc
----- Call Stack Trace -----
kgeriv_int <- kgeriv <- kgeasi <- kxfpqsrls <- kxfpqrsod
<- kss_del_cb <- kssdel <- kxfpdelqrefs <- kxfpqsod_qc_sod <- kxfpqsod
<- kxfrcls <- qerpxFetch <- qerstFetch <- qerjoFetch
Changes
No 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 |