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