need 'SELECT ANY DICTIONARY' grant
SQL
SELECT A.MODULE, A.USERNAME, A.MACHINE, B.SQL_ID, C.SQL_TEXT FROM V$SESSION A, V$ACTIVE_SESSION_HISTORY B, V$SQL C
WHERE A.SID = B.SESSION_ID
AND B.SQL_ID = C.SQL_ID
AND B.SQL_ID = 'byxtkdvmvgtpz'
GROUP BY A.MODULE, A.USERNAME, A.MACHINE, B.SQL_ID, C.SQL_TEXT;