Blocking Sessions

The Blocking Sessions tab displays the current blocking and waiting sessions in a hierarchical display.

In this tab, you can:
  • View detailed information about each blocking session, and view sessions blocked by each blocking session.

  • Inspect or drill down into the SQL involved, to determine the cause of the blocking.

  • Perform several troubleshooting operations, including terminating one or more listed sessions to resolve a waiting session problem.

The hierarchical display nests waiting sessions underneath the session that is blocking them in an easily viewable parent-child relationship. The hierarchy can contain any number of levels to correctly represent the structure of the sessions involved.

The sessions listed include sessions that are waiting for a resource, and sessions that hold a resource that is being waited on that creates a blocking condition.

For more information, see: