Re: Optimizer Statistics,Histograms and 10.2.0.2

What could help as well is:

set audit_trail to DB;

audit all on sys.dbms_stats;

Then check dba_audit_Trail to see when it was called, and by whom. Might give some further clues.

Stefan

On 11/17/06, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
>
> At 10:49 AM 11/17/2006, Fuad Arshad wrote:
> >got that done and taken care of.
> >any idea what i should pursue next
>
> List who has the privilege to gather statistics and audit those IDs.
> I doubt that it is coming from within the Oracle instance because of
> that jump in time. I have not observed that in any Oracle jobs, at
> least not with the old dbms_job types. I don't have enough experience
> with the 10g scheduler to tell for sure that it is immune to the
> daylight savings change.
>
>
> Regards
>
> Wolfgang Breitling
> Centrex Consulting Corporation
> www.centrexcc.com
>
>
>
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email
> ______________________________________________________________________
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l