Discovered these columns on the v$session and gv$session views:
FINAL_BLOCKING_INSTANCE and FINAL_BLOCKING_SESSION
These appear to be new in 11.2. I checked an 220.127.116.11 instance and they weren’t there. They were there in an 18.104.22.168 instance. Interestingly an early version of the 11.2 documentation didn’t have them. I have Oracle document E10820-03 on my hard drive and it didn’t have a reference to these columns, but the most current 11.2 docs do.
Anyway, I used these to determine which Oracle session was holding library cache locks. In earlier versions I don’t believe that the v$/gv$session views were that helpful with library cache locks. They worked with regular locks only. So, check these out when you have a locking situation and don’t know which SID is blocking the others.
Current v$session documentation here: