Prev: other than auditing, a way to see last execution time?
Next: problem deleting datafile
From: aman.oracle.dba on 3 Jul 2008 07:20
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
From: Mladen Gogala on 3 Jul 2008 07:54
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 Gogala
http://mgogala.freehostia.com
From: aman.oracle.dba on 3 Jul 2008 12:10
On Jul 3, 4:54 pm, Mladen Gogala <mgog...(a)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
From: Mladen Gogala on 4 Jul 2008 05:29
On Thu, 03 Jul 2008 09:10:49 -0700, aman.oracle.dba wrote:

> On Jul 3, 4:54 pm, Mladen Gogala <mgog...(a)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.com
 | 
Pages: 1
Prev: other than auditing, a way to see last execution time?
Next: problem deleting datafile