To fix histogram issue, DBMS_STATS.SET_PARAM can be used to modify the default attributes e.g By default, GATHER_STATS_JOB will gather histograms, which can be confirmed by running below query
select dbms_stats.get_param('method_opt') method_opt from dual;
METHOD_OPT
--------------------------------------------------------------------
FOR ALL COLUMNS SIZE AUTO
To disable histogram capture, use
exec dbms_stats.set_param('method_opt', 'FOR ALL COLUMNS SIZE 1');
In case you wish to capture histograms for some of the tables, then you can use
exec dbms_stats.set_param('method_opt', 'FOR ALL COLUMNS SIZE REPEAT')
i.e Collects histograms only on the columns that already have histograms
