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.”
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.
fpfks1
Wohh exactly what I was looking for, thankyou for posting.
Для удобства скачайте скачать akdere bet без денег и пользуйтесь всеми возможностями бесплатно.
What is Sugar Defender 24? Jeffrey Mitchell made the Sugar Defender 24. It is a product (Sugar Defender Diabetes) that helps your blood sugar health.
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.
Some really marvelous work on behalf of the owner of this internet site, absolutely outstanding content.
We’re a group of volunteers and opening a new scheme in our community. Your web site provided us with valuable info to work on. You’ve done an impressive job and our whole community will be grateful to you.
I reckon something genuinely interesting about your blog so I saved to bookmarks.
Very interesting points you have observed, appreciate it for putting up.
enpfmWAREhBCKo
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!
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.
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!
you’ve got an ideal blog here! would you prefer to make some invite posts on my blog?
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.
Its fantastic as your other content : D, thanks for posting. “Even Albert Einstein reportedly needed help on his 1040 form.” by Ronald Reagan.
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!
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.
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.
Well I definitely liked studying it. This information provided by you is very useful for good planning.
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
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 🙂
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!
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!…
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.
There’s noticeably a bundle to know about this. I assume you made certain nice factors in options also.
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!
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!
You have mentioned very interesting details! ps decent site. “Justice is the truth in action.” by Jeseph Joubert.
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
It’s hard to find knowledgeable people on this topic, but you sound like you know what you’re talking about! Thanks
Loving the information on this web site, you have done outstanding job on the posts.
Sweet internet site, super design, very clean and apply pleasant.
Hey there! I’m at work browsing your blog from my new iphone 4! Just wanted to say I love reading your blog and look forward to all your posts! Carry on the great work!
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!
You have observed very interesting details! ps nice website.
Deference to op, some fantastic information .
There is noticeably a bundle to know about this. I assume you made certain nice points in features also.
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!
If some one desires expert view on the topic of running a blog after
that i propose him/her to go to see this blog, Keep up the
pleasant work.
Feel free to visit my website :: products like prodentim
I am continuously searching online for posts that can benefit me. Thanks!
Thankyou for this wondrous post, I am glad I observed this site on yahoo.
Как вам новый дедпул? доставка мяса
zr4gu0
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!
Very energetic blog, I liked that a lot. Will there be a part
2?
Hey There. I found your blog using msn. This is
an extremely well written article. I will make sure to bookmark it
and come back to read more of your useful info. Thanks for the post.
I’ll certainly comeback.