We got sysaux tablespace full alert i checked and saw the rentention period to be 31 days.
So i reduced the period to 15 days and purged the old data.
The issue is resolved but management wants to know why it happened from last 2 weeks when the retention period was same from past 7 months .
What must have changed with sysaux and who changed it
How can i find out.
thanks in advance.