Friday, August 27, 2010

When we last gathered stats in Oracle 11G

select * from dba_optstat_operations;

To see the current retention value,

select dbms_stats.get_stats_history_retention from dual;

No comments:

Post a Comment