Blocking Sessions in Oracle

There are multiple ways to capture blocking sessions in oracle database. 1. A full query to get list of blocking sessions with BLOCKER, WAITER and OBJECT being blocked:It works on Single Instance and RAC set-up as well. 2. A simple query to find out blocking in the database: 3. To get limited information on blocking […]