Re: table getting analyzed automatically in oracle 10g

From: Mladen Gogala <>
Date: 03 Jul 2008 11:54:06 GMT
Message-ID: <486cbdde$0$1346$>

On Thu, 03 Jul 2008 04:20:04 -0700, 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 (
> any one please suggest on this.
> Regards

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
Received on Thu Jul 03 2008 - 06:54:06 CDT

Original text of this message