Skip to content

Instantly share code, notes, and snippets.

@rlcc885
rlcc885 / Locked_tables.sql
Last active August 16, 2018 04:36
Get Tables Locked in Oracle
SELECT B.Owner, B.Object_Name, A.Oracle_Username, A.OS_User_Name
FROM V$Locked_Object A, All_Objects B
WHERE A.Object_ID = B.Object_ID