If your database is running since a long time and then we might need to know the database statistics gather information from the database views like DBA_TAB_STATISTICS or DBA_TAB_STAT_HISTORY.
Limitation is that the information of stats gather is available only upto the last 5 stats gather jobs.
To go for earlier information of database stats gather, one can review following views:-
Limitation is that the information of stats gather is available only upto the last 5 stats gather jobs.
To go for earlier information of database stats gather, one can review following views:-
- WRI$_OPTSTAT_TAB_HISTORY
- WRI$_OPTSTAT_IND_HISTORY
- WRI$_OPTSTAT_HISTHEAD_HISTORY
- WRI$_OPTSTAT_HISTGRM_HISTORY
- WRI$_OPTSTAT_OPR
- WRI$_OPTSTAT_AUX_HISTORY
No comments:
Post a Comment