After a few months of operation, the grid control mgmt_tablespace can take up a few unnecessary gigabytes.
Oracle provides a package to purge the old partitions.
In order to run the package the management server must be shutdown. (due to a bug)
Then logon as SYSMAN and run:
- exec emd_maintenance.partition_maintenance;
- exec emd_maintenance.analyze_emd_schema(‘SYSMAN’);
- exec emd_maintenance.remove_em_dbms_jobs;
- exec emd_maintenance.submit_em_dbms_jobs;
We do it every 3 months and save up each time around 2Gb. (based on 75 targets)