ORA-12518, TNS-12547 and ORA-01031 are very bothering errors that we find when everything looks normal. There are numerous reason for…
September 22, 2020 Read more
Oracle Core RDBMS
One caveat of altering _rollback_segment_count to a higher value and reducing is that Oracle will never drop/remove newly created rollback…
March 14, 2019 Read more
Oracle Dictionary corruption can lead to various errors and database/instance crash. Some of the dictionary corruption may not be fatal…
December 7, 2016 Read more
Performance tuning and problem diagnosing are the two most challenging and important management task DBAs perform on their databases. AWR…
September 12, 2014 Read more
I recently came across a situation in my stage database where a new third party application was getting deployed. The…
July 19, 2012 Read more