select * from dba_optstat_operations;
To see the current retention value,
select dbms_stats.get_stats_history_retention from dual;
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
Subscribe to:
Posts (Atom)