Tuesday 10 May 2016

Query To check Locks on a Table

The relevant query is as follows:

Select object_id, session_id, oracle_username, os_user_name,
Process, locked_mode
From sys.v_$locked_object;

Select a.object_name, b.oracle_username
From all_objects a, v$locked_object b
Where a.object_id = b.object_id
And a.object_name like 'po%';

No comments:

Post a Comment