试一下关联到 V$SESSION_HISTORY 来获取模式或用户信息，可以试一下下面这个查询

SELECT SEH.SESS_ID
      ,SEH.SESS_SEQ
      ,SEH.CURR_SCH
      ,SEH.USER_NAME
      ,SQH.*
  FROM V$SESSION_HISTORY SEH
      ,V$SQL_HISTORY SQH
 WHERE SQH.SESS_ID = SEH.SESS_ID
   AND SQH.SESS_SEQ = SEH.SESS_SEQ
   AND SQH.START_TIME > SYSDATE - 1.0 / 24

--查询误删表的操作
SELECT SEH.SESS_ID
,SEH.SESS_SEQ
,SEH.CURR_SCH
,SEH.USER_NAME
,SQH.*
,SEH.*
FROM V$SESSION_HISTORY SEH
,V$SQL_HISTORY SQH
WHERE SQH.SESS_ID = SEH.SESS_ID
AND SQH.SESS_SEQ = SEH.SESS_SEQ
AND SQH.TOP_SQL_TEXT LIKE 'drop%';