cursor: pin S wait on X
Few weeks back thread came up on oracle-l freelist regarding "cursor: pin S wait on X" event . Tanel Poder replied to this thread with excellent explanation. You can read full…
Read Full RecipeFew weeks back thread came up on oracle-l freelist regarding "cursor: pin S wait on X" event . Tanel Poder replied to this thread with excellent explanation. You can read full…
Read Full RecipeRecently I faced one issue where all the connection to database hung and it was also not possible to login to database using "/ as sysdba". To get access of…
Read Full Recipe