Want to post your scripts here in this blog ? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts.

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;