Parameter _rollback_segment_count can cause trouble

Just some weeks ago we’ve learned that setting the hidden underscore parameter:

_rollback_segment_count

may cause trouble during upgrade. This parameter is used in very rare cases to have under all circumstances and situations this specified number of UNDO’s online. Now during upgrade this may result in massive latch contention  – and there’s a patch available as well. Recommendation is to unset it during upgrade.

I don’t think that many people will hit this as I personally haven’t seen databases with this underscore in their init.ora or spfiles. So take this post more or less as a reminder for myself 🙂

–Mike

Edit: I removed the mentioned bug number as it was incorrect (Dec 4, 2017)

Further Edit: As this seems to cause misunderstandings: This blog post is from 2012 and the issue described is first of all very rare, and second happened with upgrade to 11.2.0.3 only!!! (Feb 28, 2018)

2 thoughts on “Parameter _rollback_segment_count can cause trouble

  1. Please remove this blog ASAP as its not correct and creating confusion for lot of customers.
    There is no such issue for this parameter!!!!!

    • Naveen,

      would you please mind to drop me an email instead of commenting in such a rude tone?
      The blog post is 6 years old and first of all it says “This parameter is used in very rare cases”.
      Second it says as well: “So take this post more or less as a reminder for myself”.

      Thanks!
      Mike

Leave a Reply

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

* Checkbox to comply with GDPR is required

*

I agree

This site uses Akismet to reduce spam. Learn how your comment data is processed.