On Thu, 03 Jul 2008 09:10:49 -0700, aman.oracle.dba wrote:
> On Jul 3, 4:54 pm, Mladen Gogala <mgog...@[EMAIL PROTECTED]
> 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-
>> do***ented 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.com
|
