Modifying Data Retention Periods

Real-time Monitoring features use partitioning and data retention configuration.

The following are the tables along with their default retention periods. When changing any retention periods, all tables related to Real-time monitoring must be changed to the same value to ensure that data is consistent across various features.

Note:

For more information about modifying data retention values, see the chapter "Maintaining and Troubleshooting the Management Repository" in the book Oracle Enterprise Manager Administration.

Table Name	Default Retention Period	Description
EM_CCC_WATCHDOG_ALERTS	366 Days	This table stores warnings from the agents when we detect that monitoring was not active.
EM_CCC_HISTORY_JOBEXEC	366 Days	This table stores history of all Enterprise Manager Jobs that are run as part of the Real-time Monitoring functionality.
EM_CCC_OBSERVATION	366 Days	This table stores each individual observation of a user action (for example, each file change, login/logout, process start/stop, each database object change, and so on.
EM_CCC_OBSGROUP	366 Days	This table stores information about how a single observation is related to a bundle based on the bundle settings set in the Real-time Monitoring Rule's user interface.
EM_CCC_OBS_GROUP_MAP	366 Days	This table stores the relationship between each single observation bundle and the target, rule, and standard that was monitoring for that observed action.
EM_CCC_HISTORY_OBS_STATUS	366 Days	This table stores the state change history for audit status (unaudited, unauthorized, authorized) for each observation.
EM_CCC_HA_OBS	366 Days	This table stores analytic summaries of counts of observations by hour and other attributes for reporting.
EM_CCC_HA_OBSGROUP	366 Days	This table stores analytic summaries of counts of observations bundles by hour and other attributes for reporting.
EM_CCC_FILEOBS_DIFF	366 Days	This table stores past file comparison for OS File based observations.
EM_CCC_AUTHOBS_CR_MAP	366 Days	This table stores the mapping between Change Management Request System change requests that were used to authorize an observation.
EM_CCC_CMPUBACTION	366	This table stores requests to publish data from EM server to an integrated Change Management Server using the connector.
EM_CCC_CMPUBACTION_DETAIL	366	This table stores additional details for requests to publish data from EM server to an integrated Change Management Server using the connector.