11g stale stats question
Hello,
I am currently using the command dbms_stats.gather_database_stats(OPTIONS=>'LIST STALE' ... to get a list of tables with stale stats.
As I unserdtand it, it used a hard coded a 10% threashold value.
My question is, is there a way to use 5% as the threashold? (ie. list all tables with 5% or more change)
I did find the following:
I am currently using the command dbms_stats.gather_database_stats(OPTIONS=>'LIST STALE' ... to get a list of tables with stale stats.
As I unserdtand it, it used a hard coded a 10% threashold value.
My question is, is there a way to use 5% as the threashold? (ie. list all tables with 5% or more change)
I did find the following:
DBMS_STAT.set_table_prefs('SH','SALES','STALE_PERCENT',5);
but it sounded like this is only used by the automatic stats gathering??? or would my
dbms_stats.gather_database_stats(OPTIONS=>'LIST STALE' ... command also utilize the new percentage?
1