Lock Usage - Top 10 Sessions (8.0)
- Organization of this page
Overview
The Lock Usage - Top 10 Sessions (8.0) report displays information related to the top 10 sessions that currently have the largest numbers of locks on database objects. This report is displayed as a bar graph. From the displayed report, you can display more detailed drilldown reports.
Storage location
Reports/SQL/Troubleshooting/Real-Time/
Record
Process Detail (PD_PDET)
Fields
|
Field name |
Description |
|---|---|
|
Blocked Processes |
Number of processes blocked by the process |
|
DB Name |
Name of the database being used by the process at the time of record acquisition |
|
Locks |
Number of locks being requested by the process at the time of record acquisition |
|
Program |
Application program name |
|
SPID |
Process ID |
|
User |
Logon name of the user who issued the command |
Drilldown reports (field level)
|
Report name |
Description |
|---|---|
|
Session Detail (8.0) |
Displays detailed information related to resource usage in each session. To display this report, click the Locks field. |