Re: Table stats in 10.2

On Fri, 28 Apr 2006 06:06:27 -0700, EdStevens wrote:

Is there an easy explanation to how these stats are being gathered
without some manually scheduled job? And which manual do I need to
reference to get up to speed on this?

No. Your database is haunted. You have ghosts in your machine. Those
ghosts can be made visible by the following powerful magic:

select owner, job_name,system,enabled,comments
from dba_scheduler_jobs
order by enabled desc

If executed on midnight of Friday the 13th, the output looks lik this:

OWNER JOB_NAME SYSTEM ENABLED COMMENTS
------------------------------------------------------------------
SYS AUTO_SPACE_ADVISOR_JOB TRUE TRUE auto space advisor maintenance job
SYS GATHER_STATS_JOB TRUE TRUE Oracle defined automatic optimizer statistics collection job
EXFSYS RLM$EVTCLEANUP FALSE TRUE
SYS PURGE_LOG TRUE TRUE purge log job
EXFSYS RLM$SCHDNEGACTION FALSE TRUE
SYS FGR$AUTOPURGE_JOB TRUE FALSE file group auto-purge job

That will make it possible for you to perform various types of exorcism,
by using DBMS_SCHEDULER. You can find a very good description of
DBMS_SCHEDULER in Tim Hall's book: http://tinyurl.com/n4l7r

May the force be with you!

--
http://www.mgogala.com

.