EM 13c: Availability History Of Targets is Available Only for 6 months Despite the Retention Policy Is Not Set for MGMT_AVAILABILITY
(Doc ID 2690364.1)
Last updated on JULY 14, 2020
Applies to:Enterprise Manager for Oracle Database - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Availability History Of Targets is Available Only for the last 6 months Despite the Retention Policy Is Not Set for MGMT_AVAILABILITY.
One may assume that if there is no retention policy for MGMT_AVAILABILITY, history of the target availability will remain in the repository database since the time of creation.
Retention policy on MGMT_AVAILABILITY can be verified from the repository database using the following query:
Executing the following query shows the first record only from 6 months back despite the target is added a year ago.
,t.creation_date as "Target Creation Date" from
EM_AVAILABILITY_E ah, mgmt$target t
where 1=1 and ah.target_guid = t.target_guid
and t.target_name like 'middle_%'
and t.target_type = 'oracle_database'
group by t.target_name, t.creation_date
order by 1;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document