Subject: Re: OEM: Need Help to Retrieve AWR Retention Value from OEM MGMT
 Views
To: biswas.sourav@hotmail.com, Oracle Mailinglist <oracle-l@freelists.org>
References: <PN1PR0101MB2063D693238829BA505883E7F0F90@PN1PR0101MB2063.INDPRD01.PROD.OUTLOOK.COM>
From: Oleksandr Denysenko <odenysenko@gmail.com>
Message-ID: <deea80b3-faf0-acf1-9fae-3f3842b55ea3@gmail.com>
Date: Fri, 2 Feb 2018 15:55:41 +0200
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:52.0) Gecko/20100101
 Thunderbird/52.6.0
MIME-Version: 1.0
In-Reply-To: <PN1PR0101MB2063D693238829BA505883E7F0F90@PN1PR0101MB2063.INDPRD01.PROD.OUTLOOK.COM>
Content-Type: multipart/alternative;
 boundary="------------99090E753FA0821BF3749042"
Content-Language: Russian-English
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: odenysenko@gmail.com
--------------99090E753FA0821BF3749042
Content-Type: text/plain; charset=windows-1251; format=flowed
Content-Transfer-Encoding: 8bit

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


--------------99090E753FA0821BF3749042
Content-Type: text/html; charset=windows-1251
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html;
      charset=windows-1251">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <p>Hello.</p>
    <p><br>
    </p>
    <p>You, definitely, have to use <b><a moz-do-not-send="true"
href="https://docs.oracle.com/cd/E24628_01/doc.121/e24473/metric_extension.htm#EMADM10032">Metric
          Extensions</a></b></p>
    <p>1) write your metric extension</p>
    <p>2) deploy to required databases</p>
    <p>3) check for metric values in OEM Repository<br>
    </p>
    <pre class="moz-signature" cols="100">Best Regards,

    Oleksandr Denysenko</pre>
    <div class="moz-cite-prefix">02.02.2018 15:30, Sourav Biswas ןטרוע:<br>
    </div>
    <blockquote type="cite"
cite="mid:PN1PR0101MB2063D693238829BA505883E7F0F90@PN1PR0101MB2063.INDPRD01.PROD.OUTLOOK.COM">
      <meta http-equiv="Content-Type" content="text/html;
        charset=windows-1251">
      <style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
      <div id="divtagdefaultwrapper" dir="ltr" style="font-size: 12pt;
        color: rgb(0, 0, 0); font-family: Calibri, Helvetica,
        sans-serif, &quot;EmojiFont&quot;, &quot;Apple Color
        Emoji&quot;, &quot;Segoe UI Emoji&quot;, NotoColorEmoji,
        &quot;Segoe UI Symbol&quot;, &quot;Android Emoji&quot;,
        EmojiSymbols;">
        <div>Hi All,<br>
          <br>
          One of our shop has over 180 database. We need to find below
          details from all databases;<br>
          <br>
          <ul style="margin-bottom:0px; margin-top:0px">
            <li>AWR Snapshot Interval</li>
            <li>AWR Rention</li>
          </ul>
          <br>
          We want to make sure all our Prod and Non-Prod environments
          should have same value for above parameters based on our
          current policy.<br>
          <br>
          We have 12c OEM configured and have all these databases added
          to its repository.<br>
          <br>
          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"
          <a class="moz-txt-link-freetext" href="https://docs.oracle.com/cd/E24628_01/doc.121/e57277/">https://docs.oracle.com/cd/E24628_01/doc.121/e57277/</a><br>
          <br>
          However, this is a huge and detailed document. So was
          wondering if some one has worked on similar scripts.<br>
           </div>
        <br>
        <div id="Signature">Best Regards,<br>
          Sourav Biswas<br>
          <div>+91-9650017306<br>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
  </body>
</html>

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