Re: automatic gather_stat in oracle 10

From: fairlie rego <fairlie_r_at_yahoo.com>
Date: Thu, 7 Dec 2006 14:47:41 -0800 (PST)
Message-ID: <316357.90141.qm@web31911.mail.mud.yahoo.com>

There is also a scheduler . So you need to check dba_scheduler_jobs    

  select job_name,SCHEDULE_NAME,STATE from dba_scheduler_jobs where job_name='GATHER_STATS_JOB'

  -Fairlie

genegurevich_at_discoverfinancial.com wrote:   Hi everyone:

I understand that there is a gather_stat job that runs automatically in Oracle 10 (unless it is turned off manually). I don't believe it has been turned off in our environment, but when I select * from dba_jobs I don't see anything. Am I looking at an incorrect view? Where do I need to look in order to see that job?

thank you

Gene Gurevich

--

http://www.freelists.org/webpage/oracle-l

          Fairlie Rego
Senior Oracle Consultant
  http://www.linkedin.com/in/fairlierego   

  http://el-caro.blogspot.com/
  M: +61 402 792 405      

---

Need a quick answer? Get one in minutes from people who know. Ask your question on Yahoo! Answers.
--

http://www.freelists.org/webpage/oracle-l Received on Thu Dec 07 2006 - 16:47:41 CST