Re: Audit vs Logminer

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
petermag_at_singnet.com.sg
http://web.singnet.com.sg/~petermag/oracle.html

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> 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: Sean.ONeill_at_organon.ie
>
> 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: ListGuru_at_fatcity.com (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: petermag_at_singnet.com.sg

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: ListGuru_at_fatcity.com (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).