sql script: 找出stale statistics的对象

  • 2012/04/09
  • ORACLE 9i-23ai
  • 617 views
  • sql script: 找出stale statistics的对象已关闭评论

Using the code below one can find the tables/indexes that have stale statistics in a schema, when options=>’GATHER AUTO’ is used oracle gathers statistics analyzes the tables/indexes that have stale statistics.

, ,

阅读全文