Does anyone know offhand what the retention rule is for dba_hist_sql_plan and dba_hist_sqlstat?
Printable View
Does anyone know offhand what the retention rule is for dba_hist_sql_plan and dba_hist_sqlstat?
as AWR, default 7 days
In one db, the timestamp column in dba_hist_sql_plan has values from June of 2007. Just curious if this is the best place to look for obsolete objects.
There are currently 13,666 rows in sql_hist_sql_plan older than 7 days. I wonder what mechanism cleans these out.
that is something else, as you can see dba_hist_sql_plan does not containt snap_id to purge, so most probably although not proved is that purging policy is probably based a join between dba_hist_sql_plan and some other hist_sql tables.
probably the plan will be purged when the sql statement is no longer referenced in any hist_sql tables