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
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
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:
Current Oracle Certs
Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.
Follow if you like:
The next are Asian dating websites and apps you may join to find Asian love. Nonetheless, some may note that there are thousands of such platforms in the online, and choosing a particular platform shouldn’t be a simple activity, especially contemplating that a few of the sites are scams. Guidelines there do not encourage foreigners to go to there, so let us consider right here only South Korea. Nonetheless, as i have stated over, their cleverness has an impact on their very personal why not look here web dating model, and their relationship lovers are usually extraordinarily shy. Most of the subscribers you’ll encounter are from Asian moral backgrounds. You may at all times choose an inexpensive Asian hookup site if it caters to your needs. If you’d like to attach with Asian dates from other international locations, you’ll be able to try Asian hookup websites. I imply the whole crying is an indication of weakness isn’t simply an Asian factor.
Miami-Dade County´s attorney argued on Tuesday that the projection didn´t paint the whole picture and that some particular segments would see double-digit enhancements. Simply ensure you simply learn by means of the entire thing, and just remember to perceive what it actually is that you’re signing up for earlier than making a final resolution! 5. Membership and subscriptions: you’ll be able to sign up on free Asian hookup websites, but you might not make the most out of them. That’s the reason why you must verify the membership plans before you start the signup process. A really cool characteristic on FindLoveAsia is the Timeline which exhibits you new people on the platform, new pictures that members add to their profiles, and the record of members who want to start a dialog. Avoid stereotyping: since the net daters come from completely different cultural backgrounds, you should be open-minded in regards to the people you meet. Search for dates with online daters who’ve constructive character traits like kindness and loving instead of superstitious qualities.
It is likely to be frustrating to search out someone who has comparable traits should you want conventional dating. However, most courting websites with Asian ladies for on-line dating are real and authorized. They are normally very serious as in comparison with those who’re younger. 4. Big pool of subscribers: most singles who search for love choose to make use of courting websites to search out love. Like any other matchmaking webpage, you’ll meet 1000’s of singles interested in relationship, networking, or flirting. Therefore, you will encounter hundreds of singles, allowing you to choose from the numerous recommendations. Are based mostly on our focus is the best asian singles, asian date is the niche, preferences, dating site our chinese language and identification. If there are acceptable questions to ask, there will all the time be these that aren’t. Nevertheless, there are a couple of actions you possibly can take to extend your probabilities of finding a meet. There are many idateasia scam nice Asian dating sites to select from, however it actually will rely on what you are trying to find. It all depends in your needs and what you’re in search of in a relationship. Selecting a dating site over typical dating is advantageous because you both are searching for relationships.
Maybe declare intentions: Searching for something critical? 5. Area of interest dating; tailored for people who find themselves desirous about Asian dating. However the Philippines are mostly Roman Catholic. However, ever for the reason that internet turned such a mainstay in the lives of people world wide, mail order bride services are experiencing a new wave of recognition. Actually, it is possible to look for Asian bride offline and online. With their assist, each single man, regardless of his location, can meet 1000’s of wonderful ladies of Asian descent. Our mainstream suggestions have members in the tens of millions, and our niche options help a whole bunch of 1000’s of users. If you would like to attach with 1000’s of Asians for dating, you might read the Asian dating sites evaluate. Fung Brothers – Relationship Asians in the town? Even when some Chinese men were open to relationship ladies of different ethnicities, non-Chinese girls seldom responded to their messages. It’s an awesome experience for them to speak with international guys and open a new side of life. It is a superb starting point for singles contemplating Asian hookup sites.
Despite having similar views on the mode of dressing, music, and basic tradition, she expects you to have an identical outlook on basic issues. Every lady world wide has some specific issues they seek to search out in a man. Establishing a meeting with lady should not be a problem. Social media platforms like Facebook, Instagram, and Vkontakte (VK) are popular among Ukrainian women for socializing and assembly new people. That’s the reason folks all around the globe are very fascinated with dating with them. The tradition in Ukraine has made it regular for folks at hand gifts to each other as an indication of hospitality. It’s completely regular for a Ukrainian woman to ask you a lot of questions regarding your loved ones, profession and plans for the long run. Whenever you two get off oron public transportation or automobiles or whenever you two cross a road, just remember to supply your arms or prolong your hands to assist your lady. 👉 Visit Behappy2day right now and get began for free! If yes, be happy to join the UAbrides group. Before a lady gets to commit totally and be at liberty to open up around you, she has to make certain that you match all her expectations.
Since they are open with you, they also count on the identical from you. Before she will open as much as you, she needs to know the man nicely sufficient to make certain that he is somebody she will count on. While dating a Ukrainian woman can carry many advantages, it’s necessary to contemplate some potential drawbacks as well. When relationship an Ukrainian girl, it’s crucial to respect cultural variations, be genuine and honest in your intentions, and show chivalry and courtesy. It’s not as laborious to meet Ukrainian women as it is to make relationships work long-term. Engaging in conversations, commenting on posts, and respectfully interacting with Ukrainian ladies on these platforms can lead to meaningful connections. These sites supply a secure and secure surroundings to interact with Ukrainian girls, find out about their culture, and establish connections based mostly on mutual interests. Engaging in conversations and actions through these platforms might help you establish meaningful connections with Ukrainian girls. When looking for to attach with Ukrainian ladies on-line, exploring social media platforms can present further avenues to satisfy and work together with potential partners who align together with your relationship intentions. Their nurturing and caring nature makes them glorious companions in a relationship. Dating a Ukrainian woman generally is a rewarding experience attributable to her nurturing nature, robust family values, and dedication to making a harmonious residence surroundings.
Ukrainian women stand out as exceptional partners for marriage as a consequence of their nurturing qualities, dedication to household, and dedication to making a harmonious dwelling setting. Relationships are built by two people: one individual will certainly not be ready to pull out this troublesome burden. Read on to find out. The relationship web sites are very promising platform these days to search out an applicable companion. When a Ukrainian lady meets a man on the initial stage, she would possibly discover it a bit difficult to communicate with him. Visa Issues: If the relationship progresses to a severe stage, navigating visa necessities for visits or relocation will be complex. Family Expectations: Ukrainian girls charmdate usually have strong household ties, and household expectations could play a big position in your relationship. If she’s dating you, she’s already made up her mind that she’s into you, that she wants you as her partner, and that she’s not going to play video games or lead you on. Pay your consideration on the fact that the Slavic girls dwelling in Ukraine kept their conventional household values, accept a big age difference with their associate, prepared to move in Canada and dream to have a contented and loving household. Dream Singles is a premium relationship site that particularly caters to connecting males with Ukrainian and different Slavic women.
These expectations, deeply rooted in Slavic women’s values, include trustworthiness, honesty, sincerity, and a deep sense of compatibility. You will agree with us that for a relationship to be successful, particularly with a Ukrainian lady, there must be compatibility. For example, if a Ukrainian woman is courting a man who isn’t considered suitable by her family, her family members may present her with recommendation on how one can navigate the connection or encourage her to end the relationship. They also worth their household, and they aren’t fascinated by dating a guy who does not share related values. Make it clear that you are occupied with your girlfriend’s family, this is an important a part of the courting culture in Ukraine. Ukrainian ladies are very sweet, tender, and type. Ukrainian ladies should not an exception; it’s crucial you reply every query she asks, together with these that point to your past affairs with different ladies. Dating etiquette and strategy to love in Russia and Ukraine usually are not the identical as in Western international locations.