Oracle下查看某个用户下最近2天的执行的增删改事务语句

jiawang

SELECT
     a.sample_time,
     a.session_id,
     a.session_serial#,
     a.sql_id,
     s.sql_text,
     DECODE(a.sql_opcode,
            2, 'INSERT',
            6, 'UPDATE',
            7, 'DELETE',
            a.sql_opcode) AS action_type
FROM v$active_session_history a
JOIN dba_users u ON a.user_id = u.user_id
LEFT JOIN v$sql s ON a.sql_id = s.sql_id AND a.sql_child_number = s.child_number
WHERE u.username = 'NRMS'
   AND a.sample_time >= SYSDATE - 2
   AND a.sql_opcode IN (2, 6, 7)
ORDER BY a.sample_time DESC;

登录/注册后可看大图