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
