select * from X$MUTEX_SLEEP ;

ADDR                   INDX    INST_ID MUTEX_TYPE           MUTEX_TYPE_ID LOCATION_ID LOCATION                                     SLEEPS  WAIT_TIME
---------------- ---------- ---------- -------------------- ------------- ----------- ---------------------------------------- ---------- ----------
0000002A974CFBD0          0          1 Cursor Parent                    2          27 kkspsc0 [KKSPRTLOC27]                             2         53


0000002A974CFC48          1          1 Cursor Parent                    2           1 kksfbc [KKSPRTLOC1]                               1         25


0000002A974CFC48          2          1 Cursor Pin                       3           5 kkslce [KKSCHLPIN2]                         7734050 1519721358

SELECT DECODE(request,0,'Holder: ','Waiter: ')||sid sess,
id1, id2, lmode, request, type
FROM V$LOCK
WHERE (id1, id2, type) IN
(SELECT id1, id2, type FROM V$LOCK WHERE request>0)
ORDER BY id1, request
/