Alex Lima

How to find oldest STATS information?

Published by

Alex Lima

on

Using dbms_stats.get_stats_history_availability one can find date of oldest STATS information. STATS older than this timestamp cannot be restored.

SQL> select dbms_stats.get_stats_history_availability from dual;

GET_STATS_HISTORY_AVAILABILITY
—————————————————————————
09-FEB-10 10.13.18.954562000 PM -07:00

2 responses to “How to find oldest STATS information?”

  1. How to restore table statistics (STATS)? « Oracle Spin for Project Managers Avatar
    How to restore table statistics (STATS)? « Oracle Spin for Project Managers

    […] See the oldest STATs data Possibly related posts: (automatically generated)How to backup statistics?How to find if a table has row chaining?DBA_TAB_MODIFICATIONSGather statistic for Performance […]

    Like

    Reply
  2. How to restore table statistics (STATS)? | Oracle DBA Daily Experiences

    […] See the oldest STATs data Categories: General DBA Tags: Comments (0) Trackbacks (0) Leave a comment Trackback […]

    Like

    Reply

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Previous Post
Next Post

Alex Lima

About

Taking one day at a time.

Follow Us

Blog at WordPress.com.