Performance -> Blocked Sessions

This view displays a tree table of all blocked sessions. Blockers are parent nodes and waiters are child nodes.

• SID, Serial# - session id of blocker/waiter; it also contains a link which opens session details for this session.
• Status - column from v$session.status; it shows if the session is active or not
• Username - username for this database session
• Sessions Blocked - amount of sessions being blocked by this session
• Sec in Wait - column from v$session.seconds_in_wait - number of seconds waiting for the current event.
• SQL - which SQL is currently being executed by this session. It also contains a link which opens SQL Details for this session.
• Event - event on which the session is currently wainting.
• Owner - owner of object for which the session is trying to obtain the lock
• Object Name - name of the object for which the session is trying to obtain the lock
• Object Type - type of the object for which the session is trying to obtain the lock