This discussion is archived
5 Replies Latest reply: May 1, 2013 12:56 PM by EricvdS RSS

"Database Usage Statistics" / turn on auto "optimizer stats gathering"

oracletune Newbie
Currently Being Moderated
1. From OEM it appears our 11gR2 database is not running automatic "optimizer stats gathering"

2. Also from dba_feature_usage_statistics.CURRENTLY_USED is FALSE

question: how do we turn on features, that are not running, such as "optimizer stats gathering"

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points