table getting analyzed automatically in oracle 10g
From: aman.oracle.dba <aman.oracle.dba_at_gmail.com>
Date: Thu, 3 Jul 2008 04:20:04 -0700 (PDT)
Message-ID: <9f13c89b-3071-40d2-8a6c-58b7595ba5ef@m3g2000hsc.googlegroups.com>
Date: Thu, 3 Jul 2008 04:20:04 -0700 (PDT)
Message-ID: <9f13c89b-3071-40d2-8a6c-58b7595ba5ef@m3g2000hsc.googlegroups.com>
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 Received on Thu Jul 03 2008 - 06:20:04 CDT