Database Stats

Posted by admin on Sep 9, 2009 in Database |

The Oracle automated process for gathering statistics is hidden away under schedules. To find if it is active,
SELECT * FROM DBA_SCHEDULER_JOBS;

The stored procedure can be run at another time by SYS using
EXEC DBMS_STATS.GATHER_DATABASE_STATS_JOB_PROC;