How do I view a blocked session?

Answer: You can query the dba_blockers and dba_waiters views to locate blocking sessions, but you can also get this information from v$lock and v$session….Find Oracle blocking sessions

1. Find blocking sessions with v$session.
2. Find the data block for a blocking session.
3. Oracle RAC blocking sessions.