Cluster SSH tool Utility
Many times you come across scenario's when you wish to open multiple ssh windows and execute same commands.e.g You wish to see alert log for multi-node RAC simultaneously or edit sysctl.conf…
Read Full RecipeMany times you come across scenario's when you wish to open multiple ssh windows and execute same commands.e.g You wish to see alert log for multi-node RAC simultaneously or edit sysctl.conf…
Read Full RecipeIn Oracle database 11g, a new feature/enhancement has potential of bringing down the application due to multiple sessions hitting database with wrong password. As per Bug 7715339 - Logon failures…
Read Full RecipeIn one of my databases, one application query suddenly started to pick Nested-Loop joins instead of Hash-Joins and took almost 6 hours to complete which gets completed in less than 10…
Read Full RecipeI guess most of us having My Oracle Support have got email from Oracle mentioning that Critical Patch Update January 2012 has been released. Main reason behind this is Security bug…
Read Full RecipeWe were experiencing lot of session getting stuck on resmgr:cpu quantum in our database. In fact at a time we had 70 sessions which were stuck on this wait event…
Read Full RecipePLAN STABILITY How many times you have noticed a query using Index X when you wanted it to use index Y or query performing Nested Loop join when Hash Join…
Read Full Recipe