DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Table statistics are generated automatically?

  1. #1
    Join Date
    Sep 2004
    Posts
    54

    Table statistics are generated automatically?

    Table statistics are generated automatically?

    We current using Oracle 8i datanase. One of our table, without any reason keeps creating statistics and that is messing-up the execution plan.

    What this happening and how can we stop it permanently?

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Does 8i show you the last_analyzed data in the user_tables view? If so then check for jobs (DBMS_JOB or cron) that ran at around that time that might be updating statistics automatically.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Nov 2001
    Location
    UK
    Posts
    152
    You'll find that one of your jobs has a call to analyze or dbms_stats. Depending on what language your system is written in, you might be able search for either of these two keywords to find it.

  4. #4
    Join Date
    Jan 2001
    Posts
    3,134
    Quote Originally Posted by Scorby
    You'll find that one of your jobs has a call to analyze or dbms_stats. Depending on what language your system is written in, you might be able search for either of these two keywords to find it.

    What he said.
    I remember when this place was cool.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width