DISABLE optimizer stats

BEGIN
dbms_auto_task_admin.disable(client_name => 'auto optimizer stats collection', operation => NULL, window_name => NULL);
END;

# Disable all of them
BEGIN
dbms_auto_task_admin.disable();
END;

Leave a Reply

%d bloggers like this: