Reminder on locks

I’m uploading this as a reminder since a developer was asking about it. select (select username from v$session where sid=a.sid) blocker, a.sid, ‘ is blocking ‘, (select username from v$session where sid=b.sid) blockee, b.sid fromĀ  v$lock a, v$lock b...