Re: table getting analyzed automatically in oracle 10g
Date: 03 Jul 2008 11:54:06 GMT
On Thu, 03 Jul 2008 04:20:04 -0700, aman.oracle.dba wrote:
> I am facing a strange problem....
> Every night, tables in my database are getting analyzed automatically. I
> have checked, our job is configure only for Sunday, not daily.. but it
> is happening daily
> It is becoming a problem now.... because batches become slow in night
> because of this.
> it is oracle 10g (10.2.0.2)..
> any one please suggest on this.
See the schedule for GATHER_STATS_JOB. You will find that in DBA_SCHEDULER_JOBS and DBA_SCHEDULER_SCHEDULES. There is a welldocumented package called dbms_scheduler, Tim Hall wrote a book about it and you should take a look at the jobs in your database. Your job is probably not needed at all.
-- Mladen Gogala http://mgogala.freehostia.comReceived on Thu Jul 03 2008 - 06:54:06 CDT