Audit vs Logminer

From: O'Neill, Sean <Sean.ONeill_at_organon.ie>
Date: Wed, 28 Nov 2001 06:23:10 -0800
Message-ID: <F001.003CEDC2.20011128054522@fatcity.com>

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

Received on Wed Nov 28 2001 - 08:23:10 CST