Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

****************Got the opportunity to pen a Book on Database Cloud Services.......More details to follow.***************

Title : Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2020

**********************************************************************************


My Cloud Certifications:

AWS Certified Solutions Architect Associate

Azure Certified Architect

Azure Certified Administrator

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

Search This Blog

Tuesday, July 3, 2012

Disable gather stats ( default autotask jobs) job in 11g

Disable the auto stats job in 11g.


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> exec dbms_auto_task_admin.disable('auto optimizer stats collection',NULL,NULL);

PL/SQL procedure successfully completed.

SQL> exec dbms_auto_task_admin.disable(client_name =>'auto space advisor',operation => NULL,window_name => NULL);

PL/SQL procedure successfully completed.

SQL>  exec dbms_auto_task_admin.disable(client_name =>'sql tuning advisor',operation => NULL,window_name => NULL);

PL/SQL procedure successfully completed.

Related views related to automated database maintenance tasks:
DBA_AUTOTASK_CLIENT
DBA_AUTOTASK_CLIENT_HISTORY
DBA_AUTOTASK_CLIENT_JOB
DBA_AUTOTASK_JOB_HISTORY
DBA_AUTOTASK_OPERATION
DBA_AUTOTASK_SCHEDULE
DBA_AUTOTASK_TASK
DBA_AUTOTASK_WINDOW_CLIENTS
DBA_AUTOTASK_WINDOW_HISTORY

No comments: