5.2.1 Statistics Histograms
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 Oracle Banking Trade Finance 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
Parent topic: Customizing Statistics Gathering for FLECUBE