Disable Database Auto Segment Space Job

How to disable Auto Segment Space Job of the database

SQL> SELECT client_name, status FROM dba_autotask_client;

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

The auto space advisor is seen as ENABLED.

To disable the job, use the below command.

SQL> EXEC DBMS_AUTO_TASK_ADMIN.DISABLE(client_name=>'auto space advisor', operation=>NULL, window_name=>NULL);

Ensure that the job is disabled by executing the blow command. The STATUS column should show DISABLED.

SQL> SELECT client_name, status 
FROM dba_autotask_client;

22-JUN-15                                        Report of Table Rebuild Candidates

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