My Oracle Support Banner

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 later
Information 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

 
----- 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.