WRI$_OPTSTAT_HISTGRM_HISTORY : History stats.
602428Jan 25 2010 — edited Jan 26 2010Hi
One of our DBA's was worried that the table WRI$_OPTSTAT_HISTGRM_HISTORY was causing the sysaux tablesspace to grow in huge sizes. We have shrunk the number of days down to 10 and I understand we could do it further.
Couple of questions I have
1) In production environment, does everyone keep this functionality on.
2) If not then Is there a way to turn off storing historical stats.
3) If yes, the can someone can give me a good example of when I would recover historical stats. (Trying to relate to a real wold scenario).
Thanks in advance.