RE: Overhead Associated with Signon Audit in Financials 11.0

Victoria,  

Check out Tom Kyte's new book- he encourages the use of auditing, especially Oracle's built-in auditing rather than home-grown. He provides a nice bench-mark test example to compare the performance of loading 30,000 rows into both cases and native auditing won. DIY auditing had a 27% decrease in transactions/second and 146% of the CPU time. Of course, you are asking about auditing vs. no auditing performance, but you could use Tom's approach to measure performance numbers.  

Also, there is at least one document I've seen on MetaLink about moving the audit table SYS.AUD$ from the SYS schema to avoid contention/fragmentation. Check out Note 72460.1. Keeping your audit data in the DB, versus in OS text files, is recommended so that you can use DB reporting features and not have to write your own text parsing code- unless you enjoy that sort of thing :-).  

Best regards,

David B. Wagoner
Database Administrator
Arsenal Digital Solutions
Web: http://www.arsenaldigital.com <http://www.arsenaldigital.com/>

"the most trusted source for

            STORAGE MANAGEMENT SERVICES" The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone
(919-466-6700), and please delete this message and all attachments from your
system.
Thank you.

-----Original Message-----
Sent: Thursday, October 30, 2003 2:54 PM To: Multiple recipients of list ORACLE-L

Does anyone have any statistics about overhead associated with using the Signon Audit in an 11.0.3/ 8.1.7.4/8.0.6.3 environment. We are using full installs of AP, GL, FA and CE. Size of the production database is 100G. Can't tell you exactly what we'd be auditing; we are under siege by Internal Audit at the moment - they've raised the "database audit" flag, but have not started dictating what they want audited. I am trying to get some real-world statistics to arm myself with when the day comes .....

I have heard that the overhead is significant - is this true, in your experience?

Vicki Pierce
Database Administration
x2401

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: David Wagoner
  INET: dwagoner_at_arsenaldigital.com

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