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[…]

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[…]