Find Machine ID by SQL ID

nngumzzil(25)
Published in
#sql
Words
38
Reading
1 min
Listen
Play
9y
  1. need 'SELECT ANY DICTIONARY' grant

  2. 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;

Find Machine ID by SQL ID | Ecency