Note the following:

• The default statistics gathering routine decides to collect histograms on specific tables based on certain criteria that are not documented.
• Statistics Histograms are not recommended for FLEXCUBE tables.

Configure the default statistics gathered without Histograms.

/* Start of Script – Script to be executed as SYS*/

BEGIN
 DBMS_STATS.SET_PARAM (‘METHOD_OPT’,’FOR ALL COLUMNS SIZE 1’);
END;
/

/*End of Script */

Verify the setup using

SELECT DBMS_STATS.GET_PARAM (‘METHOD_OPT’) FROM DUAL;

Should return

FOR ALL COLUMNS SIZE 1