Overview On Oracle RAC Resource Mastering

The GRD is a central repository for locks and resources, it is distributed across all nodes (not a single node), but only one instance masters a resource. The process of maintaining information about resources is called lock mastering or resource mastering. I spoke about lock remastering in my BACKUP section.

If you would like to Enrich your career and get a certified professional, then enroll in our Oracle RAC Training - This course will help you to achieve excellence in this domain.

Resource affinity allows the resource mastering of the frequently used resources on its local node, it uses dynamic resource mastering to move the location of the resource masters. Normally resource mastering only happens when an instance joins or leaves the RAC environment, as of Oracle 10g R2 mastering occurs at the object level which helps fine-grained object remastering. There are a number of parameters that can be used to dynamically remaster an object

MindMajix Youtube Channel

Check out Oracle RAC Interview Questions and Answers that help you grab high-paying jobs.

_gc_affinity_time specifies interval minutes for re-mastering
_gc_affinity_limit defines the number of times instance access the resource before remastering, setting to 0 disables remastering
_gc_affinity_minimum defines the minimum number of times instances access the resource before remastering
_lm_file_affinity disables dynamic remastering for the objects belonging to those files
_lm_dynamic_remastering enable or disable remastering.


You should consult Oracle before changing any of the above parameters.

Explore Oracle RAC Sample Resumes! Download & Edit, Get Noticed by Top Employers!

 

Job Support Program

Online Work Support for your on-job roles.

jobservice

Our work-support plans provide precise options as per your project tasks. Whether you are a newbie or an experienced professional seeking assistance in completing project tasks, we are here with the following plans to meet your custom needs:

  • Pay Per Hour
  • Pay Per Week
  • Monthly
Learn MoreGet Job Support
Course Schedule
NameDates
Oracle RAC TrainingNov 19 to Dec 04View Details
Oracle RAC TrainingNov 23 to Dec 08View Details
Oracle RAC TrainingNov 26 to Dec 11View Details
Oracle RAC TrainingNov 30 to Dec 15View Details
Last updated: 04 Apr 2023
About Author

Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

read less