查看自动收集统计信息的任务及状态:
SQL> select client_name,status from dba_autotask_client;
CLIENT_NAME STATUS
---------------------------------------------------------------- --------
auto optimizer stats collection ENABLED
auto space advisor ENABLED
sql tuning advisor ENABLED
获得当前自动收集统计信息的执行时间:
1 select t1.window_name,t1.repeat_interval,t1.duration
2 from dba_scheduler_windows t1,dba_scheduler_wingroup_members t2
3* where t1.window_name=t2.window_name and t2.window_group_name in ('MAINTENANCE_WINDOW_GROUP','BSLN_MAINTAIN_STATS_SCHED')
SQL> /
WINDOW_NAME REPEAT_INTERVAL DURA