DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Does anyone know a method to store tables stats, before a new ANALYZE TABLE in 7.3.4. That would enable us after the analyze, if things get worse, to restore the old stats?


  2. #2
    Join Date
    Dec 2000
    Ljubljana, Slovenia
    In issue 24 (August 1999) of "Oracel Update" magazine (Xephon plc) I published an article "Moving Optimizer statistics between databases (Oracle 7.3)" that deals with this problem, long time before Oracle introduced DBMS_STATS package.

    Since the article is more than 2 years old you can download it for free (along with the accompaniying SQL/PLSQL code) from Xephon's site: http://www.xephon.com/oracleupdate.html

    On the bottom of the right side of the page click on "Other issues" and then find August 1999 issue. You will have to register (it is free), then the whole issue (PDF format) will be mailed to you. You can view the code online by clicking at the title of the article.

    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Jan 2002
    Thanks a bunch Jurij !

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.