Identifying Blocking Sessions in Oracle Database

By Ravi Karamsetty | November 2, 2015 |

Below SQL gives the blocker and blockee sessions in database. Oracle RAC Environment: select (select username from gv$session where sid=a.sid) blocker, a.sid, ‘is blocking’, (select username from gv$session where sid=b.sid) blockee, b.sid from gv$lock a, gv$lock b where a.block > 0 and b.request > 0 and a.id1=b.id1 and a.id2=b.id2; Oracle Non-RAC Environment: select (select username … Continue reading “Identifying Blocking Sessions in Oracle Database”

Read More

Which Mobile Platform Should I Support? - dwaprince - can you give suggestion to list out all files which are replication factor is 3 through a command line

Guide for Installation of WordPress with LAMP on CentOS 7 server - dwaprince - Excellent

Guide for Installation of WordPress with LAMP on CentOS 7 server - dwaprince - Good

TNS SQL .NET Connectivity Issues – Troubleshooting and Diagnosing Tips - dwaprince - Good