Parameter _rollback_segment_count can cause trouble

Posted by Mike Dietrich on Oracle Blogs See other posts from Oracle Blogs or by Mike Dietrich
Published on Wed, 19 Sep 2012 13:02:58 +0000 Indexed on 2012/09/19 21:44 UTC
Read the original article Hit count: 1036

Filed under:

/Oracle/Best Practice

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 due to bug14226559 - 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

Related posts about /Oracle/Best Practice

Good practice or bad practice

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, i am new to WPF and i have one question(the first one actually, more to come) Is it better to add some logic, for example the bindings for the window, in xaml or in the code behind. >>> More
PowerShell in Practice

as seen on Dot net Slackers - Search for 'Dot net Slackers'
This article is taken from the book PowerShell in Practice. As part of a chapter on recent and forthcoming innovations in PowerShell, this excerpt explores what you can do with the virtualization functions in the Hyper=V PowerShell library. >>> More
Hello it’s your server calling

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
This is nothing exciting but I've always found this startup procedure very useful. All this simple procedure does is send you an email if the SQL Service Starts. If your Server is a cluster it will tell you which node you're on. -- On it's own this procedure can't actually be… >>> More
Incorporating Sound in UPK 3.6.1

as seen on Oracle Blogs - Search for 'Oracle Blogs'
UPK 3.6.1 now offers developers the ability to easily record and edit sound from right within the UPK Developer. Sound can be recorded in either the concept pane or individual topic frames. A developer can record sound at the same time they're capturing a transaction or by adding sound after recording… >>> More
SQL Server Management Data Warehouse - quick tour on setting health monitoring policies

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Profiler, Perfmon, DMVs & scripts are legendary tools for a DBA to monitor the SQL arena. In line with these tools SQL Server 2008 throws a powerful stream with policy based management (PBM) framework & management data warehouse (MDW) methods, which is a relational database that contains the… >>> More

Developer IT