Plan Stability using Sql Profiles and SQL Plan Management
PLAN 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 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 RecipeOracle 11.2.0.2 has introduced new column "REASON" to V$SQL_SHARED_CURSORS. I came across this extremely useful column while debugging multiple child cursor issue (11.2.0.2 seems to have too many bugs which…
Read Full RecipeThis post was actually a comment from Sasi which came on previous article 10.2 CRS startup issue . I am converting it to a post so that we can get some…
Read Full RecipeAll India Oracle User Group(AIOUG) is organizing the annual Oracle Conference in Bangalore on Friday, December 9th and Saturday December 10th, 2011.Arup Nanda is key speaker this year. I will be attending…
Read Full RecipeI had installed a 11.2.0.2 RAC setup few days back with incorrect timezone. It had to be PDT but I installed with UTC. Starting/stopping clusteware with correct timezone didn't solve…
Read Full Recipe11.2.0.3 patchset is now available for download. 10404530 is available on Linux x86,x86-64 bit only. Tanel Poder first tweeted this [blackbirdpie id="117213822904840193"] Soon after this Surachart and Martin have started upgrading to…
Read Full Recipe