Sysaux Tablespace

[cjgrozo]

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

Regards

[PAVB]

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.

[cjgrozo]

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

[malay_biswal]

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

[cjgrozo]

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

[PAVB]

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

Look at DBMS_LOGMNR_D.SET_TABLESPACE.

The tablespace in four months grows 700MB

Not such a large increase in size.

[cjgrozo]

thanks for all.