Re: table getting analyzed automatically in oracle 10g
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 04 Jul 2008 09:29:39 GMT
Message-ID: <486ded83$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 well-
>> documented 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 Gogalahttp://mgogala.freehostia.com
Date: 04 Jul 2008 09:29:39 GMT
Message-ID: <486ded83$0$1346$834e42db@reader.greatnowhere.com>
On Thu, 03 Jul 2008 09:10:49 -0700, aman.oracle.dba wrote:
> On Jul 3, 4:54 pm, Mladen Gogala <mgog..._at_yahoo.com> wrote:
>> 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 well-
>> documented 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 Gogalahttp://mgogala.freehostia.com
> > Thanks mate. > I found it finally.. yes it is the problem. Now I have disabled it. > > Cheers
Your job is probably unnecessary and should probably be disabled instead of the supplied job. You can see some details here:
http://www.dba-oracle.com/t_gather_stats_job.htm
-- Mladen Gogala http://mgogala.freehostia.comReceived on Fri Jul 04 2008 - 04:29:39 CDT