Waiting Information

 

Displays information on which users are waiting for locks on objects and which users have the locks on the objects being waited for.

Figure: Session Information: Waiting Information

FO Backup Mode

Description

Connection ID:

The ID of the session.

Waiting For

The connection ID number of a user that has a lock on an object that the current user's transaction is waiting for

Be Waited By

The connection ID of a user that is waiting for release of a lock on an object held by the current user.

Table: Waiting Information


Related topic:

Monitoring Database Sessions
Monitoring Database Locks

Viewing Lock Status