RE: setting of audit_trail initialization parameter

And...
 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 databases).

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
http://www.entint.com/

http://www.entint.com/

http://www.facebook.com/pages/Enterprise-Integration/212351215444231 http://twitter.com/#!/entint http://www.linkedin.com/company/18276?trk=tyah http://www.youtube.com/user/ValueofIT

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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

TXT:SEG
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue May 21 2013 - 16:40:41 CEST