RE: Oracle Auditing

>From our production ERP DB:

SELECT MIN(timestamp), MAX(timestamp), AVG(rowsperday), SUM(rowsperday) FROM
(
SELECT TRUNC(timestamp) "TIMESTAMP", COUNT(*) "ROWSPERDAY" FROM dba_audit_trail
GROUP BY TRUNC(timestamp)
) UNION
SELECT SYSDATE, SYSDATE, 0, SUM(bytes)
FROM dba_extents de
WHERE de.segment_name = 'AUD$';

07/28/2001 06/17/2003 409.336231884058 282442
06/18/2003 06/18/2003 0 59039744

(This'll probably need formatting after e-mail mangling.)

So, we have an average of about 410 audit rows per day for the last two years, giving us a total of about 280K rows which take up a total of about 59MB of storage. Of course, we're getting close to 3K rows/day of login failures due to a bug with Perl 5.006 and DBD::Oracle with WE8ISO8859P1 NLS_LANGs. :)

HTH! :) Rich

Rich Jesse                           System/Database Administrator
[EMAIL PROTECTED]                  Quad/Tech Inc, Sussex, WI USA

> -----Original Message-----
> From: Kevin Toepke [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 18, 2003 8:50 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle Auditing
>
>
> Greetings and Salutations!
>
> At the direction of the external auditors I have been instructed to
> install/configure oracle auditing in our Oracle Applications
> databases.
> (sweet!) The next step is to estimate how much space all of
> the auditing
> information will take. (I plan on moving the data from AUD$
> to another table
> on a daily basis)
>
> Can anyone out there in oracle-l land help me give a
> reasonable estimate?
>
> TIA
>
> Kevin Toepke

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).