Statistics related Bugs -19c

Bug 30664385 - High count of repetitive executions for sql_id 35c8afbgfm40c during incremental statistics gathering (Doc ID 30664385.8)

Excessive CPU Usage Hang (Process Spins) Performance Affected (General) Performance Of Query/ies Affected Waits for "ENQ: TX - ROW LOCK CONTENTION" Waits for "CPU + Wait for CPU"

DBMS_STATS

Description
This bug is only relevant when using Partitioned Tables
Large number of repetitive executionsfor sql_id 35c8afbgfm40c:
SELECT NVL(SUM(SPARE1), 0), COUNT(*) FROM WRI$_OPTSTAT_SYNOPSIS_HEAD$ H,
(SELECT MAX(ANALYZETIME) MA FROM WRI$_OPTSTAT_SYNOPSIS_HEAD$ WHERE BO# =
:B1
) V WHERE H.ANALYZETIME = V.MA AND H.BO# = :B1
during online incremental stats load.
Rediscovery:
High count of executions for sql_id 35c8afbgfm40c.

Workaround
There is no direct workaround.
Indirect one , sql_patch to improve plan for the query execution.

Alternate Sql Plan : 3690981172

Above Plan works even for non-incremental stats. Pleaes double check with Oracle before implementing in production.