Oracle Auto task Client – Advanced Configuration

Oracle10g/11g onwards… dba_autotask_client

Disable/Enable Auto task Client

set lines 180 pages 1000
col client_name for a40
col attributes for a60
SQL> select client_name, status,attributes,service_name from dba_autotask_client
2  /

CLIENT_NAME                             “|”STATUS  “|”ATTRIBUTES|SERVICE_NAME
---------------------------------------------------------------------------------------------------------------
auto optimizer stats collection         “|”ENABLED “|”ON BY DEFAULT, VOLATILE, SAFE TO KILL
auto space advisor                      “|”ENABLED “|”ON BY DEFAULT, VOLATILE, SAFE TO KILL
sql tuning advisor                      “|”ENABLED “|”ONCE PER WINDOW, ON BY DEFAULT, VOLATILE, SAFE TO KILL
BEGIN
  DBMS_AUTO_TASK_ADMIN.disable(
    client_name => 'auto space advisor',
    operation   => NULL,
    window_name => NULL);
END;
/
BEGIN
  DBMS_AUTO_TASK_ADMIN.disable(
    client_name => 'sql tuning advisor',
    operation   => NULL,
    window_name => NULL);
END;
/
BEGIN
  DBMS_AUTO_TASK_ADMIN.disable(
    client_name => 'auto optimizer stats collection',
    operation   => NULL,
    window_name => NULL);
END;
/
21:20:36 SQL> select client_name, status,attributes,service_name from dba_autotask_client
21:20:36   2  /

CLIENT_NAME                             “|”STATUS  “|”ATTRIBUTES" |"SERVICE_NAME"
--------------------------------------------------------------------------------------------------------------
auto optimizer stats collection         “|”DISABLED“|”ON BY DEFAULT, VOLATILE, SAFE TO KILL
auto space advisor                      “|”DISABLED“|”ON BY DEFAULT, VOLATILE, SAFE TO KILL
sql tuning advisor                      “|”DISABLED“|”ONCE PER WINDOW, ON BY DEFAULT, VOLATILE, SAFE TO KILL

🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.