Re: table getting analyzed automatically in oracle 10g
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 03 Jul 2008 11:54:06 GMT
Message-ID: <486cbdde$0$1346$834e42db@reader.greatnowhere.com>
Date: 03 Jul 2008 11:54:06 GMT
Message-ID: <486cbdde$0$1346$834e42db@reader.greatnowhere.com>
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.
>
> 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 http://mgogala.freehostia.comReceived on Thu Jul 03 2008 - 06:54:06 CDT