Differences

This shows you the differences between two versions of the page.

--- databaseauditing [2015/07/21 08:30] – [Purging Audit Trail] z0hpvk
+++ databaseauditing [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 19: / Line 19: @@
 This still means that failed logins are audited.
-==== View Audit Trail ====
+==== Viewing Audit Trail ====
 SQL below will show everything that has been audited today
@@ Line 25: / Line 25: @@
 <code>alter session set nls_date_format = 'DD-MON-YYYY HH24:MI';
 set linesize 160
-col os_username format a20
+col os_username format a15
-col userhost format a25
+col userhost format a45
-select os_username, username, action, userhost, timestamp
+select os_username, username, returncode, userhost, timestamp
 from dba_audit_trail
 where timestamp > trunc(sysdate)
@@ Line 43: / Line 43: @@
 /</code>
-Create a job to set Archive Time. In this case it will be over 30 days
+Create a job to set the Archive Timestamp. In this case it will be over 30 days
 <code>BEGIN
   DBMS_SCHEDULER.CREATE_JOB (
@@ Line 58: / Line 58: @@
 /</code>
-Create a purge job which will delete all audit entries older than the Archive Time.
+Create a purge job which will delete all audit entries older than the Archive Timestamp.
 <code>BEGIN
   DBMS_AUDIT_MGMT.CREATE_PURGE_JOB(