Example: Who Is Waiting for a Lock?
The following query shows which sessions are waiting for locks in the VNODE "GRFR6":
update ima_mib_objects
set value = 'GRFR6'
where classid = 'exp.gwf.gwm.session.control.add_vnode'
and instance = '0'
and server = DBMSINFO('IMA_SERVER');
select distinct
resource_id,
lock_id,
lock_state,
ima_locklists.locklist_id,
locklist_server_pid,
locklist_session_id,
effective_user,
db_name,
session_terminal,
session_query
from
ima_locks,
ima_locklists,
ima_server_sessions
where lock_state != 'GR'
and ima_locks.locklist_id = ima_locklists.locklist_id
and ima_locklists.locklist_server_pid = ima_server_sessions.server_pid
and ima_locklists.locklist_session_id = ima_server_sessions.session_id;