Changing OEM12c Repository retention settings

Today, I’ve been working on a script to pull some sizing/metric information out of the Oracle Enterprise Manager (OEM) repository database.  As I was working through (pulling my hair out…lol) the details; I had a discussion with an good friend.  He mentioned to me that I needed to change  the retention setting on the repository for usage with the script (I was working on) and long-term historical tracking.   Although, I already knew this needed to be done, it took some poking around to find the document number in MOS.

In case you want to check out the document or documentation, you can find this information at these points of interest:

http://docs.oracle.com/cd/E25178_01/doc.1111/e24473/repository.htm
MOS Doc ID: 1405036.1

Armed with the documentation and a few more grey hairs, I took at look at what default settings were configured after building the repository.  The script in Listing 1 will display what the current/default retention settings are.

Listing 1: Script for retention settings
select table_name, partitions_retained
from em_int_partitioned_tables
where table_name in (‘EM_METRIC_VALUES’,’EM_METRIC_VALUES_HOURLY’,’EM_METRIC_VALUES_DAILY’);

After running the script in Listing 1, your output should tell you if you are configured with the default settings.  The default settings for retention are 7, 32 and 12.  Figure 1 shows you the output from the environment I’m working in.  As you can see, the retention settings have not been changed.

Figure 1: Current retention settings

image

These numbers may look a bit funny when you first look at them.  Before changing theses settings it is good to understand what these values mean.  The values for EM_METRIC_VALUES and EM_METRIC_VALUES_HOURLY are displayed in DAYS  The value for EM_METRIC_VALUES_DAILY is displayed in MONTH.

For tracking and historical purposes, these settings are a bit low.  Most organizations will want to have data that is retained for longer period of times; mostly due to security and compliance reasons.  Now, this brings up the topic of how to change these values.

Oracle has provided a PL/SQL API to allow these changes to be done.  The SQL statements in Listing 2 shows how this API is used for each of the retention changes.

Listing 2: PL/SQL API to change retention settings

BEGIN
  gc_interval_partition_mgr.set_retention(‘SYSMAN’, ‘EM_METRIC_VALUES’, 10);
END;
/

BEGIN
  gc_interval_partition_mgr.set_retention(‘SYSMAN’, ‘EM_METRIC_VALUES_HOURLY’, 90);
END;
/

BEGIN
  gc_interval_partition_mgr.set_retention(‘SYSMAN’, ‘EM_METRIC_VALUES_DAILY’, 36);
END;
/

Changes that were made by the PL/SQL API, the retention setting for the OEM repository have been changed.  Figure 2, shows you the updated information that the repository will use.

Figure 2: Updated retention settings

image

With the updated settings, the OEM repository will now keep raw metric data for 10 days, hourly metric data for 90 days (3 months) and keep all the daily metric data for 36 months (3 years).  This increase in retention should help with reporting on growth of monitored targets over the long term.

Enjoy!

twitter: @dbasolved

blog: http://dbasolved.com

Please follow and like:
Comments
  • So if you’re hardly ever time sure guy and cant afford to have actual relationship or a man who went by means of this conventional means of finding a love but couldn’t succeed then online dating is boon for you. This manner, you may get to be related to those who you will have too much in widespread with. There you will get to know one another more specifically. You could perceive that there are 1000’s of people who go to dating websites to find actual love and companions for a lifetime. One of the successful online dating sites is perfectmatch. Soulful Match is the title of an online dating site that gives on the spot messaging free of charge. A dating site might ask you questions and match you with somebody with related pursuits. However excitement overrules concern especially if you already found that good somebody whom you will be sharing your lifetime with.

    Imagine it or not you can find a perfect match as per your likings with little endurance of endurance and sensibility. Majority of the courting websites present you an alternative to test their site at no cost to start with and might afterwards improve to a bit of month-to-month subscription cost. Such sites might be catering qpid network to one ethnic group akin to, Asian dating or offering companies to people who find themselves extra mature similar to seniors courting. The clients on that site are well respected and are severe about giving everybody respect on the location. That site has many joyful shoppers and really do work for singles out there. In the true world, there’s comparatively extra effort and hesitation whereas approaching a person, whereas the benefit of courting apps is that the efforts are lowered as a result of each events already perceive each other’s willingness on online dating sites. I would strive their social networking application earlier than trying different dating websites. You can be part of considered one of many social anxiety-free chat rooms. And so, with her life coach (Lauren Zander, who guided her by her divorce), Lux is disrupting the wilds of online dating with a nontoxic site of her own: the newly launched La Vette Social Membership.

    When turbulent technological pressure has largely penetrated every facet of humane life how can discovering suitable associate stays solely a bodily course of. In actual fact, that’s specially what that website is for: find a companion online to spend your life with. Yow will discover partner as per your character sort. If you’re fortunate enough you may find the proper particular person fro you or at the top of day you nay discover that the particular person you’re going with from a very long time doesn’t resemblances your character and consequently you have to half with it. Fortunately, majority of them have provisions forFree Online Chat that helps folks to remain linked at any time from any a part of the world. The choices should not hundred or thousands however hundreds of thousands that too from any a part of t he world. The options are sturdy, the user base is various, and the security measures are top-notch. In the same report by Sensor Tower, we are able to see speedy progress in the user bases of each Hinge and Bumble over the past three years. Not solely do they use a really person pleasant site, they even have a extremely high match price. With little patience and little endurance you possibly can have your dream mate.

    You’re going to seek out a variety of great people in no time in case you just put a bit effort into it. Alternatively, you can make nice connections or just spend a while chatting with attention-grabbing people and successfully tackling your anxiety. It is perhaps an incredible possibility to satisfy innovative folks. Bygone are the days when people meet over physical places share glares adopted by formal talks and then the long course of begins to know one another by way of phone or via direct meeting. The Internet has opened up a whole new world for us whereby we can meet and discuss to individuals living hundreds of miles away. Andy: Mobile is so vital, many talk about it being the future however it isn’t; it’s now. It has been five weeks now but it feels as if all of it started a couple of days again solely. Now there is no such thing as a reason to be single in Toronto anymore.

Leave a Reply

Your email address will not be published. Required fields are marked *

Enquire now

Give us a call or fill in the form below and we will contact you. We endeavor to answer all inquiries within 24 hours on business days.