For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hello Team,
How do I change the statspack retention from 10 days to 25 days in stats$snapshot table?
Current configuration
select round(sysdate-min(snap_time)) "RETENTION" from stats$snapshot;
RETENTION ---------- 10