Facing error ORA-20012: Statistics Advisor

Hello Oracle Enthusiasts,

I am trying to run optimizer statistics advisor on a table to check for recommendations in Oracle 19c db(19.5.0.0.0)

on IBMPC/WIN_NT649.1.0 OS and facing error on below step 3 after around 13minutes of runtime.Also did not find any references in metalink on this error.

Please advice.

Step 3:

DECLARE

tname VARCHAR2(32767);

ret VARCHAR2(32767);

BEGIN

tname := 'STAT_ADVISOR_FBHQ5T1NYVB5F';

ret := DBMS_STATS.EXECUTE_ADVISOR_TASK(tname);

END;

/

DECLARE

*

ERROR at line 1:

ORA-20012: Statistics Advisor: Error during task execution: ORA-00604: error

occurred at recursive SQL level 1

ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 891

ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 3454