To find the queries running for more than 5 or x of minutes you can try the below query and change the seconds parameter as per your need:

Query:

SELECT S.USERNAME
,Q.SQL_ID
,ROUND (S.LAST_CALL_ET, 2) TIME_IN_SECONDS
,ROUND (S.LAST_CALL_ET / 60, 2) TIME_IN_MINS
,S.SID
,Q.SQL_TEXT
FROM GV$SESSION S, V$SQL Q
WHERE S.SQL_ID = Q.SQL_ID
AND STATUS = 'ACTIVE'
AND USERNAME LIKE '%APPS%'
AND S.LAST_CALL_ET > 300;

Output:

USERNAME SQL_ID TIME_IN_SECONDS TIME_IN_MINS
—————————— ————- ————— ————
SID
———-
SQL_TEXT
——————————————————————————–
APPS 497wh6n7hu14f 10562436 176040.6
331
BEGIN FND_CP_GSM_IPC.Get_Message(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); END;

1 row selected.

Note: 300 is (5*60). change it as you want to.