gather dictionary stats - cheeyoung/sqlplus-public GitHub Wiki
SQL> execute dbms_stats.gather_dictionary_stats ;
or
SQL> execute dbms_stats.set_global_prefs('AUTOSTATS_TARGET' , 'ORACLE') ;
202284808.1
178.7.115 SET_GLOBAL_PREFS Procedure
Table 178-123 SET_GLOBAL_PREFS Procedure Parameters
Parameter | Description |
---|---|
pname | ... AUTOSTATS_TARGET ... |
Table 178-124 Global Statistics Preferences
Preference | Description |
---|---|
AUTOSTATS_TARGET | ... 'ORACLE' - Statistics collected for all Oracle owned objects ... This preference is applicable only for automatic statistics collection. |