RAC Dynamic Remastering (DRM) Freeze Waits (11g)

Following is a brief account of some serious issues we had with DRM on a 3 node RAC system running 11g R2.

We had intermittent spikes that were severe enough to disrupt service. Here is a section from a 10-minute ASH showing DRM related wait “gcs drm freeze in enter server mode.”

drm2

Our first attempt was to disable DRM by setting _gc_policy_time=0. But even after that change, we had significant DRM related  waits.

It appeared that the lmon and lms0 background processes were the root of the drm waits. ora_lmon_node_1, experienced “gcs drm freeze in enter server mode”  waits,  while ora_lms0_node_1 experienced “ges lms sync during dynamic remastering and reconfig” wait. ora_lmon_node_1 was the blocker.

Following are some observations.

• DRM activity _gc_policy_time=0 was not on database tables or indexes. Maybe undo remastering was happening.

09:42:46 SQL> WITH t
09:56:15   2       AS (SELECT /*+materialize*/
09:56:15   3                 data_object_id
09:56:15   4             FROM gv$policy_history
09:56:15   5            WHERE TO_DATE (event_date, 'mm/dd/yyyy hh24:mi:ss') >
09:56:15   6                     TO_DATE ('03/07/2016 06:00:00', 'mm/dd/yyyy hh24:mi:ss'))
09:56:15   7  SELECT *
09:56:15   8    FROM dba_objects
09:56:15   9   WHERE data_object_id IN (SELECT data_object_id FROM t);
 
no rows selected

• GRD (Global Resource Directory) is frozen during remastering activity(lmon and lms0). This causes sessions to wait on “gcs drm freeze in enter server mode”

• UNDO remastering could happen if _gc_undo_affinity is set to TRUE (even if  _gc_policy_time=0)

It seems _gc_policy_time is the only param to set to disable DRM in 11g. Unfortunately, parameters like _gc_undo_affinity  are not well documented.

In an unrelated Metalink note with Doc ID 14588746.8, it suggests the following to disable DRM in 11g.

Workaround
Disable DRM by setting:
_gc_policy_time=0
_gc_undo_affinity=false <= suggesting it is still needed in 11g to disable DRM?

Solution

Finally, Oracle support recommend  to set _lm_drm_disable=7  since _gc_policy_time=0 did not seem to eliminate the drm waits. This can be set dynamically set  without having to bounce the DB.

alter system set “_lm_drm_disable=7”  scope=both  sid=’*’;

Set the level to 4 to disable DRM for read-mostly only, 5 to disable DRM for all but undo, and 7 to disable DRM for all including undo.

_lm_drm_disable=7 eliminated the DRM related waits.

107 thoughts on “RAC Dynamic Remastering (DRM) Freeze Waits (11g)”

    1. Thank you, I’ve just been searching for info about this topic for a while and yours
      is the best I have came upon till now. But, what in regards to
      the bottom line? Are you certain about the supply?

      Reply

  5. whoah this blog is magnificent i love reading your articles. Keep up the good work! You know, many people are hunting around for this information, you can help them greatly.

    Reply

  11. I’m still learning from you, as I’m trying to reach my goals. I certainly love reading everything that is written on your site.Keep the information coming. I enjoyed it!

    Reply

  12. I’ll immediately take hold of your rss feed as I can not in finding your email subscription hyperlink or newsletter service. Do you’ve any? Please permit me recognize so that I could subscribe. Thanks.

    Reply

  13. Thanks a lot for sharing this with all people you actually recognise what you’re talking about! Bookmarked. Kindly also talk over with my site =). We can have a hyperlink change arrangement among us!

    Reply

  15. Thanks for sharing superb informations. Your website is very cool. I am impressed by the details that you’ve on this website. It reveals how nicely you understand this subject. Bookmarked this website page, will come back for extra articles. You, my pal, ROCK! I found simply the information I already searched everywhere and just couldn’t come across. What a perfect website.

    Reply

  17. It’s appropriate time to make some plans for the future and it’s time to be happy. I have read this post and if I could I wish to suggest you some interesting things or advice. Perhaps you can write next articles referring to this article. I wish to read more things about it!

    Reply

  18. Thanks for some other informative web site. The place else may I am getting that type of info written in such an ideal method? I’ve a mission that I am just now operating on, and I’ve been on the look out for such information.

    Reply

  19. I conceive this site contains some very fantastic info for everyone :D. “Anybody who watches three games of football in a row should be declared brain dead.” by Erma Bombeck.

    Reply

  21. Cool blog! Is your theme custom made or did you download it from somewhere? A theme like yours with a few simple adjustements would really make my blog jump out. Please let me know where you got your design. Kudos

    Reply

  22. Awsome info and right to the point. I am not sure if this is truly the best place to ask but do you guys have any thoughts on where to employ some professional writers? Thx 🙂

    Reply

  23. Hey! Quick question that’s completely off topic. Do you know how to make your site mobile friendly? My weblog looks weird when browsing from my apple iphone. I’m trying to find a theme or plugin that might be able to resolve this issue. If you have any recommendations, please share. Thank you!

    Reply

  24. I found your blog site on google and examine a couple of of your early posts. Proceed to maintain up the excellent operate. I just further up your RSS feed to my MSN Information Reader. Looking for ahead to reading more from you in a while!…

    Reply

  25. Do you have a spam issue on this website; I also am a blogger, and I was wondering your situation; we have created some nice methods and we are looking to swap strategies with other folks, why not shoot me an e-mail if interested.

    Reply

    1. What’s Happening i’m new to this, I stumbled upon this I’ve discovered It absolutely
      helpful and it has aided me out loads. I am hoping to give a contribution & help different users like its helped me.

      Great job.

      Reply

  27. Hi this is somewhat of off topic but I was wanting to know if blogs use WYSIWYG editors or if you have to manually code with HTML. I’m starting a blog soon but have no coding knowledge so I wanted to get advice from someone with experience. Any help would be greatly appreciated!

    Reply

  28. Have you ever thought about including a little bit more than just your articles? I mean, what you say is valuable and all. But imagine if you added some great visuals or video clips to give your posts more, “pop”! Your content is excellent but with pics and videos, this site could definitely be one of the very best in its niche. Good blog!

    Reply

  30. I just could not depart your site prior to suggesting that I actually enjoyed the standard information a person provide for your visitors? Is gonna be back often in order to check up on new posts

    Reply

  35. you are actually a good webmaster. The website loading pace is amazing. It kind of feels that you are doing any distinctive trick. Furthermore, The contents are masterwork. you have performed a wonderful activity in this topic!

    Reply

  39. My spouse and I absolutely love your blog and find nearly all of your post’s to be precisely what I’m looking for. Would you offer guest writers to write content to suit your needs? I wouldn’t mind publishing a post or elaborating on some of the subjects you write related to here. Again, awesome web log!

    Reply

    2. Excellent blog you have got here.. It’s difficult to find quality writing like yours these days.

      I really appreciate individuals like you! Take care!!

      Reply

  45. Hi there, just became alert to your blog through Google, and found that it’s really informative. I’m going to watch out for brussels. I will appreciate if you continue this in future. Lots of people will be benefited from your writing. Cheers!

    Reply

  49. You really make it seem so easy with your presentation but I find this matter to
    be actually something which I think I would never understand.
    It seems too complicated and very broad for me.
    I’m looking forward for your next post, I’ll
    try to get the hang of it!

    Reply

  50. Throughout the awesome scheme of things you receive a B- with regard to effort. Where you lost me personally was first on your facts. As it is said, details make or break the argument.. And it could not be much more accurate at this point. Having said that, allow me say to you just what exactly did deliver the results. Your article (parts of it) is highly persuasive and that is most likely why I am making an effort in order to comment. I do not really make it a regular habit of doing that. Second, despite the fact that I can easily notice a leaps in reason you come up with, I am not necessarily sure of how you appear to unite your details which inturn produce the conclusion. For now I shall subscribe to your position however wish in the foreseeable future you link the dots much better.

    Reply

  52. I have noticed that over the course of making a relationship with real estate homeowners, you’ll be able to come to understand that, in every real estate transaction, a commission amount is paid. Ultimately, FSBO sellers really don’t “save” the payment. Rather, they struggle to earn the commission by way of doing an agent’s occupation. In the process, they spend their money and time to complete, as best they might, the tasks of an agent. Those responsibilities include displaying the home via marketing, representing the home to prospective buyers, building a sense of buyer emergency in order to induce an offer, preparing home inspections, handling qualification investigations with the lender, supervising repairs, and assisting the closing of the deal.

    Reply

  53. Magnificent goods from you, man. I have remember your stuff previous to and you’re simply extremely fantastic. I really like what you’ve bought here, certainly like what you’re stating and the way through which you say it. You’re making it enjoyable and you still take care of to stay it smart. I can’t wait to read far more from you. That is actually a great web site.

    Reply

  54. excellent submit, very informative. I ponder why the other specialists of this sector don’t notice this. You should proceed your writing. I’m confident, you’ve a huge readers’ base already!

    Reply

    2. Hello, Neat post. There’s a problem with your website in web explorer, could check this?
      IE still is the market chief and a large part of
      other folks will miss your fantastic writing due to this problem.

      Reply

  55. Wonderful work! This is the kind of information that should be shared across the internet. Disgrace on Google for no longer positioning this post upper! Come on over and visit my site . Thank you =)

    Reply

  59. Как совмещать учёбу и работу?
    Лучшие лайфхаки для написания работы — тут

    Reply

  61. A) Stand with a dumbbell in every hand dealing with away
    from a bench together with your right leg prolonged back and foot on high
    of the bench. Opt for the heaviest you can, while nonetheless with the flexibility to keep good type.
    Finally, the challenge lies in maintaining motivation and pushing yourself to realize your health objectives regardless of the setting.
    At the health club, you’re surrounded by tools and the focused setting can help maintain you motivated and on track.

    You even have access to specialised machines that can make sure exercises simpler to scale up or down. To do that effectively, rotate via completely different muscle groups every
    day to allow for proper recovery, guaranteeing
    you’re not working the identical muscle tissue consecutively.
    Don’t fear, I’m not going to have you ever doing equipment-heavy workout routines just like the Barbell Bench Press.

    If you don’t have a bench, you possibly can lay on the
    floor as a substitute. Give your muscles about forty eight hours to
    recuperate after a exercise. Muscular Tissues want time to heal and develop new muscle
    cells, so you must enforce this 2-day resting interval if you wish to
    see outcomes and if you need to keep away from getting injured.
    Think About combining a dumbbell push-up, renegade
    row and squat clean thruster into one transfer — hello
    man maker.
    When she’s not doing fitness things, Marnie enjoys exploring together with her canine, a mischievous rescue Akita.
    All previous workout weeks may be found beneath, or you’ll find a way to click on here to
    go straight to this week’s drop. Where you can, slow down the
    eccentric (downward motion) to create more muscle-building pressure.
    Strengthening the shoulders helps improve your posture and helps cease the dreaded ape-like posture that comes from sitting an extreme amount of
    and playing with your phone. Rhomboids and
    mid-traps – the rhomboids and mid-traps are situated between and across your scapulae or shoulder blades.

    In a world where a fully stocked health club is unavailable or residence exercise area is
    restricted, the dumbbell is all that’s required. Generally, the best muscle-building applications revolve
    across the basics. Belief me, with the best
    mindset, you have the keys to unlocking a world of features with just a pair of dumbbells.

    The dumbbell push press is an explosive overhead press that brings the hips and knees into play
    to allow for heavier dumbbells for use. This makes it a great
    exercise for building muscle mass and explosive power.
    These workouts are incredibly effective when accomplished correctly.
    With these 25 compound dumbbell workout routines you possibly can put collectively hundreds
    of creative, difficult exercises that can change your health
    eternally. It’s a single limb train, it’s a variation on a
    row, you presumably can carry massive weights, it’s practical and helpful in each high and low rep workouts and it trains anti-rotation, which is an enormous bonus.

    These are the biggest and most superficial muscle of the lateral abdomen. Sitting on high of
    the inner obliques and transverse abdominis, the external obliques offer you a defined and chiseled
    look to your midsection, framing your abs. Like
    the hanging leg raises these could be made easier by bending
    your knees to reduce back the size of the second arm.
    B) Holding a dumbbell in every hand, maintain your weights by your
    shoulders. Slowly extend your arms in the direction of the ceiling and hold,
    then lengthen the weights back down in path of your
    shoulders. A) Seize a dumbbell in every hand and
    lie face up on a bench set at a 45-degree incline.

    You should really feel like the previous few reps are difficult by the tip of your final set
    for each train. If you’re a newbie or nonetheless mastering your kind, it’s finest to err on the side of lighter dumbbells.

    You’ll find that you can lift heavier weights for certain exercises whereas some are more difficult, and for this reason it’s useful to
    have different dumbbell weight options. The complete amount
    of muscle mass utilized in compound movements
    makes them a really efficient energy training exercise.

    Let’s get into our ultimate guide to one of the best
    dumbbell workouts. There are a few issues you are able to do to mitigate this drawback.
    Instead of lowering the burden on a regular cadence, try taking 4-6 seconds.
    One Other thing you can do is add a 2-3 second pause
    on the most difficult a half of the raise.

    References:

    steroids before and after women (dmatter.net)

    Reply

  64. Hey just wanted to give you a quick heads up. The words in your content seem to be running off the screen in Internet explorer. I’m not sure if this is a format issue or something to do with internet browser compatibility but I figured I’d post to let you know. The style and design look great though! Hope you get the problem resolved soon. Thanks

    Reply

Leave a Reply

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