Archive for April, 2013

DBA_AUTOTASK in Oracle Database

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

Advertisements