Just looking for a gentle prod in the right direction.
The biggest usage in my sysaux (10.2.0.3) tablespace are the following:
SM/OPTSTAT
SM/AWR
Now I've adjusted my awr retention policy and its taken affect (off topic but how often is this done and does MMom do it?).
Now I haven't figured out how to reduce the OPSTAT usage...
Like I said just a gentle prod...