Oracle数据库统计信息应多久运行一次?

SELECT owner, table_name, last_analyzed FROM all_tables ORDER BY last_analyzed DESC NULLS LAST; --Tables.
SELECT owner, index_name, last_analyzed FROM all_indexes ORDER BY last_analyzed DESC NULLS LAST; -- Indexes.

SELECT * FROM dba_autotask_client WHERE client_name = 'auto optimizer stats collection';

SELECT window_group_name, window_name FROM dba_scheduler_wingroup_members;

SELECT window_name, start_time, duration FROM dba_autotask_schedule;

EXEC dbms_stats.gather_schema_stats(ownname=>NULL, cascade=>TRUE); -- cascade=>TRUE means include Table Indexes too.

-- Probably need to CONNECT / AS SYSDBA
EXEC dbms_stats.gather_database_stats;

http://www.acs.ilstu.edu/docs/Oracle/server.101/b10752/stats.htm

http://dba-tips.blogspot.com/2014/09/script-to-ease-gathering-statistics-on.html