ORACLE query lock resource statement

author: admin Post: August 28, 2023 117read 0Comment

ORACLE query lock resource statement
the
oracle query lock resources:
[sql]
select b. SESSION_ID,
b.ORACLE_USERNAME,
b.OS_USER_NAME,
b. PROCESS,
b. LOCKED_MODE,
a.owner,
a.object_name,
a.object_id,
a.object_type,
b.XIDUSN, www.2cto.com
b.XIDSLOT,
b.XIDSQN
from all_objects a, v$locked_object b
where a.object_id = b.object_id
the
the
Author ziwen00

This article is from the internet and does not represent1024programmerPosition, please indicate the source when reprinting:https://www.1024programmer.com/oracle-query-lock-resource-statement/