RE: setting of audit_trail initialization parameter

  • From: "Patterson, Joel" <jpatterson@xxxxxxxxxx>
  • To: "JBECKSTROM@xxxxxxxxx" <JBECKSTROM@xxxxxxxxx>, oracle-l-freelist <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 21 May 2013 10:40:41 -0400

I do DB.

 Instead of using the oracle package to manage it, (AUD$), because it would 
still get large, I created a package that detects if a 'history' table exists 
and maintains number of keep records in both history and AUD$.  It runs via EM 
across all databases  (So execute immediate is needed for it to compile on some 

The history table is in its own tablespace if it exists, and if so, then there 
is only around 35 days of data in AUD$.   This help a lot with full table scans 
and programs that seem to access it all the time -- DBSNMP or anything else 
(there are no indexes).   The oracle package maintains it, but it is still 
large even if not in SYSTEM tablespace anymore.

No program cares about the history table since it is not named AUD$.   The data 
is only needed, well, when needed, so no need to have these full table scans.

Joel Patterson
Database Administrator
904 928-2790

Joel Patterson
Sr. Database Administrator | Enterprise Integration
Phone: 904-928-2790 | Fax: 904-733-4916!/entint

This message (and any associated files) is intended only for the use
of the addressee and may contain information that is confidential,
subject to copyright or constitutes a trade secret. If you are not the
intended recipient, you are hereby notified that any dissemination,
copying or distribution of this message, or files associated with this
message, is strictly prohibited. If you have received this message in
error, please notify us immediately by replying to the message and
deleting it from your computer. Messages sent to and from us may be
monitored. Any views or opinions presented are solely those of the
author and do not necessarily represent those of the company. [v.1.1]

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Jeffrey Beckstrom
Sent: Tuesday, May 21, 2013 9:09 AM
To: oracle-l-freelist
Subject: setting of audit_trail initialization parameter

I know what the docs say but what do people really set this to;  DB, OS or XML 
and why?

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority Information Systems
1240 W. 6th Street
Cleveland, Ohio 44113



Other related posts: