Home

QUERYING ORACLE HIDDEN PARAMETERS

  QUESTIONS How to query the hidden initialization parameters? How to view list of hidden parameters? How to view hidden parameters in Oracle? How to find oracle hidden parameters? List all hidden database parameters. View hidden initialization parameters. See all initialization parameters.   REQUEST A…

A BLOCKING SESSION

  QUESTIONS What is a blocking session? What is a waiting session? How to find a blocking session? Why my transaction hangs when I try to update a row? Who blocked my transaction?   SYMPTOMPS Users complain about an application completely hangs. A user complains…