information on where the database advisors collected information is stored in
DBA_AUTOTASK_CLIENT
CLIENT_NAME STATUS CONSUMER_GROUP CLIENT_TAG WINDOW_GROUP SERVICE_NAME WINDOW_DURATION_LAST_7_DAYS WINDOW_DURATION_LAST_30_DAYS
----------------------------------- -------- -------------------- ---------- -------------------- -------------------- ------------------------------ ------------------------------
auto optimizer stats collection ENABLED ORA$AUTOTASK OS ORA$AT_WGRP_OS +000000002 12:00:00.138406000 +000000010 07:59:59.711243000
auto space advisor ENABLED ORA$AUTOTASK SA ORA$AT_WGRP_SA +000000002 12:00:00.138406000 +000000010 07:59:59.711243000
sql tuning advisor ENABLED ORA$AUTOTASK SQ ORA$AT_WGRP_SQ +000000002 12:00:00.138406000 +000000010 07:59:59.711243000
Our management what to know whats the affect of disabling these jobs and where is the information collected by these autotask jobs stored in ??