Auditing - Revision history

Stuart: /* Audit Inserts on a particular table */

2016-04-12T13:18:00Z

‎Audit Inserts on a particular table

2016-04-12T13:17:26Z

‎Run the audit cleanup

2016-04-12T12:55:16Z

‎Which tablespace is the standard auditing table (AUD$) going to?

2016-02-18T11:08:26Z

2016-01-07T14:33:47Z

‎Move the standard audit trail (AUD$) to a different tablespace

2016-01-07T13:28:48Z

‎AUD$ has not been cleaned up and is now too big to work with

2016-01-07T12:30:58Z

‎AUD$ has not been cleaned up and is now too full to work with

2015-12-15T11:23:49Z

‎AUD$ has not been cleaned up and is now too full to work with

2015-12-13T12:22:38Z

‎AUD$ has not been cleaned up and is now too full to work with

2015-12-11T17:56:58Z

‎AUD$ has not been cleaned up and is now too full to work with

@@ Line 161: / Line 161: @@
 ===Audit Inserts on a particular table===
 select owner
 ,      segment_name
@@ Line 228: / Line 229: @@
 from   dba_fga_audit_trail
+/
+</pre>
 ====Which tablespace is the standard auditing table (AUD$) going to?====
 <pre>
@@ Line 261: / Line 262: @@
+/
 </pre>
 ===AUD$ has not been cleaned up and is now too big to work with===
 Trim down the audit table the old-fashioned way...

@@ Line 160: / Line 160: @@
 </pre>
-SYS@ENDP1> select owner,segment_name,segment_type,bytes/1024/1024/1024 from dba_segments where segment_name ='QUERY_RESULT';
+===Audit Inserts on a particular table===
 OWNER                          SEGMENT_NAME                                                                      SEGMENT_TYPE       BYTES/1024/1024/1024
@@ Line 166: / Line 174: @@
 ENDUR_PRD1                     QUERY_RESULT                                                                      TABLE                        .702148438
-SYS@ENDP1>
-:06:06 SYS@ENDP1> /
+select count(1)
    COUNT(1)
@@ Line 174: / Line 184: @@
 row selected.
@@ Line 221: / Line 228: @@
 from   dba_fga_audit_trail
+/
 ====Which tablespace is the standard auditing table (AUD$) going to?====

@@ Line 159: / Line 159: @@
 end;
 </pre>
 ====Which tablespace is the standard auditing table (AUD$) going to?====

@@ Line 3: / Line 3: @@
 * [https://oracle-base.com/articles/11g/auditing-enhancements-11gr2 Oracle-Base 11gR2 Auditing enhancements]
 * [https://support.oracle.com/epmos/faces/DocumentDisplay?id=1362997.1 Basic example to manage AUD$ table in 11.2 with dbms_audit_mgmt and dbms_scheduled_jobs]
 ===Has your database migrated to Unified Auditing?===
 <pre>

@@ Line 162: / Line 162: @@
 Can move both the standard and the fine-grained access (fga) audit trail in one go by specifying "audit_trail_db_std" as audit_trail_type.
 <pre>
 begin
      dbms_audit_mgmt.set_audit_trail_location ( audit_trail_type           => dbms_audit_mgmt.audit_trail_aud_std

@@ Line 229: / Line 229: @@
+/
-alter table aud$ tablespace audit_dt
+alter table aud$ move tablespace audit_dt
+/

@@ Line 235: / Line 235: @@
 on     aud$ (sessionid, ses$tid)
         tablespace audit_dt
+/

@@ Line 182: / Line 182: @@
 Trim down the audit table the old-fashioned way...
 <pre>
 #!/usr/bin/ksh

@@ Line 189: / Line 189: @@
 create tablespace audit_dt_temp
-     datafile '/oracle/PN7/oradata5/audit_dt_temp.dbf'
+     datafile '/oracle/${ORACLE_SID}/oradata5/audit_dt_temp.dbf'
      size 500M
      autoextend on
@@ Line 217: / Line 217: @@
 create tablespace audit_dt
-     datafile '/oracle/PN7/oradata1/audit_dt.dbf'
+     datafile '/oracle/${ORACLE_SID}/oradata1/audit_dt.dbf'
      size 500M
      autoextend on