Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005

    Unanswered: Oracle Performance Issue with dbms_stats.gather_table_stats

    Hello experts,

    May I have your input regarding abovementioned title.

    I use to run dbms_stats.gather_table_stats at midnight daily for all tables, as well as dbms_stats.gather_index_stats for all indexes.

    However, while executing dbms_stats.gather_table_stats table ABC (likely to take 50mins), the HP-UX server crash and failover.

    The failover was sucessful but then from that on, all queries related to that table ABC have serious performance issue.

    Would or should the unfinish execution of dbms_stats.gather_table_stats on table ABC causes this performance issue?

    It yes, may i know why and how?

    *It is for Oracle 9i.


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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