Re: dbms_stats.gather_table_stats

Posted by Laurel on Mar 23, 2025; 9:33pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/dbms-stats-gather-table-stats-tp12958p12961.html

Hi again!
Could it be this ?
======
SQL> select dbms_stats.get_prefs('AUTOSTATS_TARGET') from dual ;

DBMS_STATS.GET_PREFS('AUTOSTATS_TARGET')
--------------------------------------------------------------------------------
AUTO

SQL>exec DBMS_STATS.SET_GLOBAL_PREFS('AUTOSTATS_TARGET','ORACLE')
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.


BUT I already disabled autotask previously... by :
SQL> exec DBMS_AUTO_TASK_ADMIN.DISABLE(client_name => 'auto optimizer stats collection',operation => NULL,window_name => NULL);
PL/SQL procedure successfully completed.
SQL> commit;

Its not good that it takes so much IO by those dbms_stats calls. Have you seeing such behavior ?
Thx alot!
Br,Laurel