DBA Hub

📋Steps in this guide1/1

View/modify stats retention

-- View current stats retention

oracle configurationintermediate
by OracleDba
12 views
1

View/modify stats retention

Code/Command (click line numbers to comment):

1
2
3
4
-- View current stats retention
select dbms_stats.get_stats_history_retention from dual;
-- Modify the stats retention
exec DBMS_STATS.ALTER_STATS_HISTORY_RETENTION(60);

Comments (0)

Please to add comments

No comments yet. Be the first to comment!