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;

Leave a Reply

XHTML: You can use these tags:' <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Copyright © 2008-2017 Brinsmead Data Services All rights reserved.