Hello All, In a 19.15 version database we are seeing stats gather failing with error - "ORA-01008: not all variables bound". And its coming from within "SYS.DBMS_STATS" package. This is mostly happening in the 19C version as we have not encountered this error when we were on 11.2.0.4. And the odd thing is it seems to be failing intermittently. Some execution are going successful but some are failing.
Seeing below bug in MOS seems to be matching with the error. But its saying solution as delete and again gather stats. This table is very big i.e. in TB's . So wanted to check here, if anyone encountered this errors and any other workaround exist for this?
Error ORA-1008 While Collecting Table Statistics on Partition Table (Doc ID 2424717.1)