select s1.username || '@' || s1.machine
|| ' ( SID=' || s1.sid || ' ) is blocking '
|| s2.username || '@' || s2.machine || ' ( SID=' || s2.sid || ' ) ' AS blocking_status, s1.SQL_ID
from v$lock l1, v$session s1, v$lock l2, v$session s2
where s1.sid=l1.sid and s2.sid=l2.sid
and l1.BLOCK=1 and l2.request > 0
and l1.id1 = l2.id1
and l2.id2 = l2.id2;

Popularity: 16% [?]

You Should Also Check Out This Post:

• System Administrator Appreciation Day
• Troubleshooting for startup inconsistent DB
• Linux System information
• set hostname without reboot
• ssh[23593]: [ID 530472 user.error] Kerberos mechanism library initialization error:

More Active Posts:

• Ssh in Solaris (2)
• ERROR! MySQL manager or server PID file could not be found! (1)