SELECT * from v$lock t 
WHERE t.TYPE IN('TM','TX');

SELECT t.blocking_session_status, t.blocking_session, t.*
  FROM v$session t
 WHERE t.blocking_session IS NOT NULL;
 
SELECT * from  v$session t
WHERE t.SID=46;

SELECT * from v$sql t WHERE t.SQL_ID='6cvrkfxrrf5z4';

SELECT * from v$transaction t WHERE t.SES_ADDR='00000000C1EA4930';

SELECT * from v$active_session_history t
WHERE t.SQL_ID='6cvrkfxrrf5z4'
ORDER BY 2 DESC;