Enable Auto Task Maintenance Jobs in Oracle Scheduler Window Manually

There are 3 auto task maintenance jobs in Oracle and they are listed below.
1.   auto optimizer stats collection
2.   auto space advisor
3.   sql tuning advisor

You can use below mentioned SQL to list the status of the jobs.
select client_name, status
 

dba topics. Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google