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 Gogala
http://mgogala.freehostia.com
|
