How to disable auto space advisor in Oracle 11g

book

Article ID: 160791

calendar_today

Updated On:

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;

/