8i Database, W2K server. Apps team looking for audit trail functionality. I've outlined the pros and cons of Oracle Audit vs using Logminer to extract audit info from archived redo logs as below:
- Archiving of Redo Logs will be carried out in any case. - All required auditing data as far as I can determine would be captured in redo logs. - Using Logminer to investigate them looks like it would be more difficult than using Oracles Auditing features. - Introducing Oracle Auditing has limited functionality and has a performance overhead. - Oracle auditing would require programming of triggers to capture before and after values which in turn has another potential performance hit. - Oracle audit data needs to be monitored and requires additional management time. I've not used Oracle Auditing or Logminer so the above is based upon some reading I've done. If I've missed any important points please give me feedback on same. Also anyone any opinions, or better still experience, as to which is better from performance POV. ------------------------- Sean O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
