Rollback Segment Count settings in Oracle Database

One caveat of altering _rollback_segment_count to a higher value and reducing is that Oracle will never drop/remove newly created rollback segments. The segments will be OFFLINE after you restart the database. I just did some experiments with _rollback_segment_count in Primary/Standby environment. From Primary, we can see _rollback_segment_count is set to 0 and 11 rollback segmentsRead more about Rollback Segment Count settings in Oracle Database[…]

Oracle Dictionary Corruption and Ways to Analyze the Issue

Oracle Dictionary corruption can lead to various errors and database/instance crash. Some of the dictionary corruption may not be fatal and it may throw error only when a DML or DDL is attempted on the corrupted object. Here I am going through an ORA-600 error is raised when drop is attempted on a table. ORA-00600:Read more about Oracle Dictionary Corruption and Ways to Analyze the Issue[…]