https://technology.amis.nl/2005/09/26/select-trigger-in-oracle-database-introducing-fine-grained-auditing/

http://www.dba-oracle.com/t_audit_sql_select_statements.htm

http://www.dba-oracle.com/class_audit/audit_trail_db_extended.htm

1 Comment

• researchadmin said 6 years ago Reply

  SELECT sysdate, a.* FROM dba_audit_trail a
  where timestamp > sysdate - 1
  and userhost = '<hostname>'
  order by timestamp desc
  
  select * from sys.aud$ r
  where ntimestamp# > sysdate - 1
  and userhost = '<hostname>'
  order by ntimestamp# desc
  

You must log on to comment.