RE: auditing tables

Auditing is a definite overhead but the degree varies depending on what auditing is set up and how many transactions you have.

Auditing can tell you who did what to a table (IUD etc). What it will not do is store before and after values. If that is what you want then triggers are required. Obviously if a new record is going to be written to an audit table every time a record in the master table is changed then that can cause significant database activity which will have an overhead on performance and possibly space as well depending on the volumes.

Another workround could be to use Logminer to check what a user has done and when. This is perhaps more suitable for a one off security check that a method of tracing every change by any user at any time.

Realy it is a matter of negotiating requirements v performance v implementation time/costs and identifying which solution (or mixture of the above) provides the necessary facilities

HTH John

-----Original Message-----
From: Foelz.Frank [mailto:Foelz.Frank_at_Scheidt-Bachmann.de] Sent: 28 January 2002 14:11
To: Multiple recipients of list ORACLE-L Subject: auditing tables

Hi all,

does anyone have experience in using Oracle's possibilities of auditing a database ??

I am interested in performance questions i.e. is it a hughe loss of performance
when auditing tables Inserts/Updates/Deletes. Should I use triggers instead ?

any hints (comments, websites, etc...) are welcome.

> Frank <

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Foelz.Frank
  INET: Foelz.Frank_at_Scheidt-Bachmann.de


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




=========================================================
This electronic message contains information from the mmO2 plc Group 
which may be privileged or confidential. The information is intended to be 
for the use of the individual(s) or entity named above. If you are not the 
intended recipient be aware that any disclosure, copying, distribution or 
use of the contents of this information is prohibited. If you have received 
this electronic message in error, please notify us by telephone or email 
(to the numbers or address above) immediately.
=========================================================