Sunday, February 21, 2016

How to disable automatic statistics collection in 11g


BEGIN
DBMS_AUTO_TASK_ADMIN.DISABLE(
client_name => 'auto optimizer stats collection',
operation => NULL,
window_name => NULL);
END;
/

to verify:

SQL> select client_name,status from Dba_Autotask_Client;

CLIENT_NAME                        STATUS
---------------------------------- --------
auto optimizer stats collection    DISABLED
auto space advisor                 ENABLED
sql tuning advisor                 ENABLED

No comments:

Post a Comment