Oracle Database Discussions

Hello,

I am using Oracle 11.1.0.7 on Solaris 5.10. I am wondering what the difference is between the CLIENT_NAME and STATUS columns in the DBA_AUTOTASK_TASK and DBA_AUTOTASK_CLIENT views is. I am seeing differences between these values that I can't explain.


Here's the SQL and output I am referring to. Can anyone explain the difference in STATUS between the views?


select client_name, status
from DBA_AUTOTASK_CLIENT;

CLIENT_NAME STATUS

auto optimizer stats collection DISABLED
auto space advisor DISABLED
sql tuning advisor DISABLED

select CLIENT_NAME, STATUS
from dba_autotask_task ;

CLIENT_NAME STATUS

auto optimizer stats collection ENABLED
auto space advisor ENABLED
sql tuning advisor ENABLED

Thanks,

Richard Brieck