Reset "_gc_policy_minimum" parameter to its default.
No more frequent remastering of objects. I’ve moved my blog from https://insanedba.blogspot.com to https://dincosman.com Please update your bookmarks and follow/subscribe at the new address for all the latest updates and content. More up-to-date content of this post may be available there. As default value of "_gc_policy_minimum"(formerly known as _gc_affinity_minimum) is quite low for busy environments, Those who are setting this parameter to 15000 according to the Best Practices and Recommendations for RAC databases with SGA size over 100GB (Doc ID 1619155.1) , I have good news for you. From 19.20 (19c DBRU JUL '23) on, You may reset it to its default value. Due to internal bug 34729755, 15000 is the new default in 23c, 19c DBRU JUL '23, and 19c ADB. DBAs having compulsive tuning disorder like me won't have to tune this parameter any more in those releases or later. According to the DRM - Dynamic Resource management (Doc ID 390483.1) , DRM attribu...