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[…]
Category: Oracle Core RDBMS
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[…]
A Peek into the SQL with most Redo Log Generation
I recently came across a situation in my stage database where a new third party application was getting deployed. The issue was with the amount of redo log generated in a day. The whole database was just 40G and it was generating about 300G of redo log per day. This made me to think moreRead more about A Peek into the SQL with most Redo Log Generation[…]