My tablespace Sysaux this growing quickly. Exists some way of purification to reduce the size? delete something, etc.
Regards
Printable View
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
Look at DBMS_LOGMNR_D.SET_TABLESPACE.Quote:
Originally Posted by cjgrozo
Not such a large increase in size.Quote:
Originally Posted by cjgrozo
thanks for all.