RE: Oracle Auditing

Kevin,

   It widely depends on what you are auditing, and how (eg per access / per session). If it's per access (certainly an overkill) a sum(executions) from v$sql group by command_type can put you on the right tracks for the number of records you may expect (check also the oldest loading time to see how much you can expect per day). If it's per session the HWM as indicated in the alert.log file is at least a first piece of information. But really, it can go from not much to more than what your databases contain already.

HTH, SF

>----- ------- Original Message ------- -----
>From: Kevin Toepke <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Wed, 18 Jun 2003 05:50:15
>
>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
>Technical Analyst
>R+L Carriers
>(937) 382-1494 x1308
>(800) 558-5456 x1308
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  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).