重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: Oracle下查看某个用户下最近2天的执行的增删改事务语句 [打印本页]

作者: jiawang 时间: 3 天前
标题: Oracle下查看某个用户下最近2天的执行的增删改事务语句

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;