Keyboard shortcuts

Press ← or → to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

History -> Blocked Sessions

Blocked Sessions Form

Form allows to select which Database to analyze in which period (From and To).

Chart

Blocked Sessions Chart

Chart displays amount of blocked sessions in selected period. One of the bars (the highest one) is of red colour - this means that the table bellow the chart refers to the same point-in-time as the red bar.

Tree Table of Blockers and Waiters

Blocked Sessions Tree Table

Treetable displays who was blocking who. The columns are as follows:

  • SID - Session ID (composed of <inst_id>.<sid>.<logon_time>)
  • Status - Status of the session as reported by v$session.status
  • Username - Username for this session
  • Sec in Wait - Seconds in wait as reported by v$session.seconds_in_wait
  • SQL - SQL that is currently being executed. You can click on it to see more details.
  • Previous SQL - SQL that was executed before the current one. You can click on it to see more details.
  • Event - Event which is being waited on.
  • Owner - Schema owning the object that was locked and being waited on.
  • Object Name - Name of the object that was locked and being waited on.
  • Object Type - Type of the object that was locked and being waited on.