Re: table getting analyzed automatically in oracle 10g
Date: Thu, 3 Jul 2008 09:10:49 -0700 (PDT)
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
I found it finally.. yes it is the problem. Now I have disabled it.
Cheers Received on Thu Jul 03 2008 - 11:10:49 CDT