Locked Objects

Locked Objects

Getting the SID and Serial number of the locking and locked objects

Finding and killing sessions, according to the os users

A view to see the locks

The following SQL query can be used to find the numbers of any hanging processes in the V_$LOCKED_OBJECT view.

Check the query from the SQL_ADDRESS column.

The previous line should end the session. If there’s no response, end the process according to operating system user.
The following query can be used to find the process ID through the operating system.

After connecting as a root user: