如何查看以普通用户身份执行的实际Oracle SQL语句

SELECT sql_text, executions, rows_processed
FROM v$sql
WHERE username = 'YOUR_USER_NAME';

SELECT s.username, s.sid, s.serial#, sql_text
FROM v$session s
JOIN v$sqlarea a ON s.sql_address = a.address AND s.sql_hash_value = a.hash_value
WHERE s.username = 'YOUR_USER_NAME';

AUDIT SELECT TABLE BY ACCESS;
AUDIT INSERT TABLE BY ACCESS;
AUDIT UPDATE TABLE BY ACCESS;
AUDIT DELETE TABLE BY ACCESS;

SELECT username, action_name, sql_text
FROM dba_audit_trail
WHERE username = 'YOUR_USER_NAME';

BEGIN
  DBMS_MONITOR.SESSION_TRACE_ENABLE(session_id => &sid, serial_num => &serial#, waits => TRUE, binds => FALSE);
END;
/