Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Table stats in 10.2

Re: Table stats in 10.2

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Fri, 28 Apr 2006 23:49:07 GMT
Message-Id: <pan.2006.04.28.23.49.06.213359@sbcglobal.net>


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
Received on Fri Apr 28 2006 - 18:49:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US