数据库自动任务

[oracle@jhemr01 xj]$ `sqlplus / as sysdba`

SQL*Plus: Release 11.2.0.4.0 Production on Sat Nov 2 16:33:53 2019

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

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

SQL> BEGIN
  2  `dbms_auto_task_admin.disable(client_name=>'auto space advisor',operation=>NULL,window_name=>NULL);`
  3  END;
  4  /

PL/SQL procedure successfully completed.

SQL> BEGIN
  2  `dbms_auto_task_admin.disable(client_name=>'sql tuning advisor',operation=>NULL,window_name=>NULL);`
  3  END;
  4  /

PL/SQL procedure successfully completed.

SQL> `select client_name ,status from DBA_AUTOTASK_CLIENT;`

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

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options