disable automatic statistics gathering

Manually statistics collection
If you already have a well-established statistics gathering procedure or if for some other reason you
want to disable automatic statistics gathering for your main application schema, consider leaving it on
for the dictionary tables. You can do so by changing the value of AUTOSTATS_TARGET parameter to
ORACLE instead of AUTO using DBMS_STATS.SET_GLOBAL_PREFS procedure.

exec dbms_stats.set_global_prefs('AUTOSTATS_TARGET','ORACLE');

Niciun comentariu:

Trimiteți un comentariu