How to disable auto space advisor in Oracle 11g

Products

• Data Loss Prevention Enforce

Issue/Introduction

When Oracle 11g is installed, the maintenance utility "auto space advisor" is installed as being "enabled".  DLP makes no use of this utility.

Resolution

In the interest of saving resources, auto space advisor can be disabled by running the following script from SQLPlus logged in as SYS as SYSDBA:

BEGIN
     DBMS_AUTO_TASK_ADMIN.disable(client_name => 'auto space advisor',
                                  operation   => NULL,    
                                  window_name => NULL);
END;
/