Sharing Oracle Database Learnings

You can query the DBA_AUTOTASK_OPERATION to find out the names and status of the automatic tasks in your database as shown in the following example:

SELECT client_name, status FROM dba_autotask_operation;

CLIENT_NAME                                                      STATUS  
---------------------------------------------------------------- --------
auto optimizer stats collection                                  ENABLED 
auto space advisor                                               ENABLED 
sql tuning advisor                                               ENABLED 

3 rows selected.

Continue reading →