EM12c Partition Maintenance and Stats

In previous versions of Oracle Enterprise Manager you would call the EMD_MAINTENANCE package to execute certain maintenance tasks such as partition maintenance and statistics gathering.
EMD_MAINTENANCE.ANALYZE_EMD_SCHEMA
EMD_MAINTENANCE.PARTITION_MAINTENANCE

In OEM12c these procedures are replaced by:
EMD_MAINTENANCE.GATHER_SYSMAN_STATS
EMD_MAINTENANCE.DAILY_MAINTENANCE

The daily_maintenance procedure actually calls gc_interval_partitions and gathers stats on Saturday. Not quite sure why that was hardcoded but I guess they figured that monitoring was least likely to be impacted on that day. If the OEM DBMS jobs are down you can also submit them by logging in the to the repository database as SYSMAN and execute the package:

Begin
     emd_maintenance.submit_em_dbms_jobs();
End;
/

Note that these procedures are automatically run through scheduled jobs once the job_queueue_ processes parameter is set to a value greater than 0.





Comments

Popular posts from this blog

Viewing ASM trace files and alert logs in Unix/Linux

ORA-00020: maximum number of processes (%s) exceeded

Troubleshooting RAC Public Network Failure