Performance -> Locked Objects

Search Locked Objects

Form allows searching for specific objects.

• Owner - owner of the object that is being searched for.
• Object Name - name of the object that is being searched for.

Both fields are using LIKE operator, so you can use % as a wildcard.

Locked Objects

Table displays list of locked objects (according to filter in the form above).

• Object ID - ID as specified in dba_objects.object_id
• Object Owner - owner of the locked object
• Object Name - name of the locked object
• Locks Count - amount of locks that are held on this object

You can select any of the rows to refresh the child table Locked Rows.

Locked Rows

This is a child table of Locked Objects above. It displays list of rows locked in selected table (if object is a table).

• SID, Serial# - session id of the session that hold the lock
• Username - lock holder username
• OS User - OS username of lock holder (refers to v$session.os_user column)
• Machine - Machine of lock holder (refers to v$session.machine column)
• Locked Mode - In what mode the lock is acquired
• Requested Mode - In what mode the lock is requested, but not yet acquired
• ROWID - of the row being locked (when available and when appropriate for the lock type)