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


Oracle (580) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips

acehints.com Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer