SQL> select * from v$locked_object;
XIDUSN XIDSLOT XIDSQN OBJECT_ID SESSION_ID ORACLE_USERNAME OS_USER_NAME PROCESS LOCKED_MODE
---------- ---------- ---------- ---------- ---------- ---------------- --------------- --------------------
13 13 681477 79913476 855 MDSOSS mdsdb2 12897 6
7 41 600151 79914479 998 MDSOSS npmuser 10468 3
7 41 600151 79914483 998 MDSOSS npmuser 10468 3
7 41 600151 79914481 998 MDSOSS npmuser 10468 3
19 27 701115 79913681 1032 MDSOSS mdsdb3 8658 6
61 30 182840 153240 1059 MDSOSS oracle 12738 3
61 30 182840 212 1059 MDSOSS oracle 12738 3
61 30 182840 165 1059 MDSOSS oracle 12738 3
30 7 545652 79915059 1073 MDSOSS npmuser 20387 3
52 39 385940 79913551 1085 MDSOSS mdsdb3 12960 6
51 17 461665 79914748 1090 MDSOSS npmuser 15454 3
51 17 461665 79914763 1090 MDSOSS npmuser 15454 3
58 24 262815 79914375 1175 MDSOSS npmuser 6369 3
58 24 262815 79914380 1175 MDSOSS npmuser 6369 3
58 24 262815 79914378 1175 MDSOSS npmuser 6369 3
10 46 680893 79913459 1179 MDSOSS mdsdb2 2581 6
17 rows selected
SQL> select * from v$locked_object;
XIDUSN XIDSLOT XIDSQN OBJECT_ID SESSION_ID ORACLE_USERNAME OS_USER_NAME PROCESS LOCKED_MODE
---------- ---------- ---------- ---------- ---------- ---------------- --------------- --------------------
42 22 507847 79915291 976 MDSOSS npmuser 25324 3
42 22 507847 79915263 976 MDSOSS npmuser 2532