Sysaux Tablespace

My tablespace Sysaux this growing quickly. Exists some way of purification to reduce the size? delete something, etc.

Regards

How big is it?
What's your retention policy?

You can look at DBMS_LOGMNR_D.SET_TABLESPACE to move logminer tables to a different tablespace.
You can lower retention policy.
You can keep adding space to it.

Thanks, for response.
In details is:
select dbms_stats.get_stats_history_availability from dual; (01/11/07)
select dbms_stats.get_stats_history_retention from dual; (31)
The awr is default 7 days
In addition, let me know, how i know the retention policy, and which is the procedure for moving tables to a different tablespace.

The tablespace in four months grows 700MB and i can adding space.

Thanks

You can query v$sysaux_occupants to check which is contributing more. The plan accordingly.

Thanks, Malay, but exist any way of reduce of size some occupants???
LOGMNR 6080
SM/AWR 123328
SM/ADVISOR 171264
SM/OPTSTAT 119360
SM/OTHER 7552
EM 105344

Quote:

---

Originally Posted by cjgrozo

... and which is the procedure for moving tables to a different tablespace.

---

Look at DBMS_LOGMNR_D.SET_TABLESPACE.

Quote:

---

Originally Posted by cjgrozo

The tablespace in four months grows 700MB

---

Not such a large increase in size.

thanks for all.