Blocking Sessions in Oracle
Oracle is known for its tuning, reliability, and robustness. But unlike any complex setup, it can face blocking session issue which directly impacts on its performance for SQL statements. Blocking session occurs when one session holds the resources which are requested by another session. Another session has no option other than to wait for the …