Re: OEM: Need Help to Retrieve AWR Retention Value from OEM MGMT Views

Hello.

You, definitely, have to use *Metric Extensions <https://docs.oracle.com/cd/E24628_01/doc.121/e24473/metric_extension.htm#EMADM10032>*

1. write your metric extension
2. deploy to required databases
3. check for metric values in OEM Repository

Best Regards,

     Oleksandr Denysenko

02.02.2018 15:30, Sourav Biswas ïèøåò:
> Hi All,
>
> One of our shop has over 180 database. We need to find below details from all databases;
>
> * AWR Snapshot Interval
> * AWR Rention
>
>
> We want to make sure all our Prod and Non-Prod environments should have same value for above
> parameters based on our current policy.
>
> We have 12c OEM configured and have all these databases added to its repository.
>
> I'm looking for assistance in creating SQL script using SYSMAN's MGMT Views. I am trying to figure
> this out using, Oracle's document "Enterprise Manager Cloud Control Management Repository Views
> Reference" https://docs.oracle.com/cd/E24628_01/doc.121/e57277/
>
> However, this is a huge and detailed document. So was wondering if some one has worked on similar
> scripts.
>
> Best Regards,
> Sourav Biswas
> +91-9650017306

--
http://www.freelists.org/webpage/oracle-l