Blocked Sessions (8.0)
- Organization of this page
Overview
The Blocked Sessions (8.0) report displays the information related to sessions that are waiting for lock release by other sessions. This report is displayed as a table. From the displayed report, you can display more detailed drilldown reports.
Note that the performance of a session that repeatedly waits for lock release declines.
Storage location
Reports/SQL/Troubleshooting/Real-Time/
Record
Lock Detail (PD_LD)
Fields
|
Field name |
Description |
|---|---|
|
Blocking Flag |
This flag indicates whether or not the lock is a blocking lock. The following values are valid:
|
|
DB Name |
Database name related to lock resource |
|
Demand Flag |
This flag indicates whether or not the lock is a request lock. The following values are valid:
|
|
Lock Type |
Lock type (lock request mode and lock resource type) |
|
Orphan Flag |
This flag indicates whether or not the lock is an isolated lock. The following values are valid:
|
|
Program |
Name of the application program that is requesting the lock |
|
SPID |
Process ID that is requesting the lock |
|
Table |
Table name if the lock resource is a table or row |
|
User |
Logon name of the user who issued the command |
Drilldown reports (field level)
|
Report name |
Description |
|---|---|
|
Lock Detail (8.0) |
Displays detailed information related to each lock. To display this report, click the Lock Type field. |
|
Session Detail (8.0) |
Displays detailed information related to resource usage status in each session. To display this report, click the SPID field. |