-
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.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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
-
Originally Posted by cjgrozo
... and which is the procedure for moving tables to a different tablespace.
Look at DBMS_LOGMNR_D.SET_TABLESPACE.
Originally Posted by cjgrozo
The tablespace in four months grows 700MB
Not such a large increase in size.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|