Oracle 11g jobs enabled by default .

check the status of the jobs from the below query :

select * from DBA_AUTOTASK_CLIENT

and if the they are enabled and you don't need these jobs, try the below commands to disable them.


SQL> BEGIN
DBMS_AUTO_TASK_ADMIN.disable( 2
3 client_name => 'auto optimizer stats collection',
4 operation => NULL,
5 window_name => NULL);
6 end;
7 /

PL/SQL procedure successfully completed.

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> commit;

Commit complete.

SQL>


and now again check the status.