OEM: Need Help to Retrieve AWR Retention Value from OEM MGMT Views
From: Sourav Biswas <biswas.sourav_at_hotmail.com>
Date: Fri, 2 Feb 2018 13:30:38 +0000
Message-ID: <PN1PR0101MB2063D693238829BA505883E7F0F90_at_PN1PR0101MB2063.INDPRD01.PROD.OUTLOOK.COM>
Hi All,
+91-9650017306
Date: Fri, 2 Feb 2018 13:30:38 +0000
Message-ID: <PN1PR0101MB2063D693238829BA505883E7F0F90_at_PN1PR0101MB2063.INDPRD01.PROD.OUTLOOK.COM>
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-lReceived on Fri Feb 02 2018 - 14:30:38 CET