I have used LogMiner once, and I was quite surprised at the Redo Log details. For example, all SQL that does not modify the database will not be captured into the Redo Log file. (eg, SELECT statement). But Auditing definitely can capture all these. Similarly if you issue the same update statement multiple nos of times, only one is updated into the Redo Log file. Auditing will record multiple nos of times as entered.
Peter Teoh [EMAIL PROTECTED] http://web.singnet.com.sg/~petermag/oracle.html ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, November 28, 2001 5:45 AM > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Teoh 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).
