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