RE: Overhead Associated with Signon Audit in Financials 11.0

Vicki,

As long as your *Purge* Audit signon data, I really do not see any significant overhead. We have a 200 Gb DB and see no issues. What level is your Profile set to? The advantages of Signon Audit far outweighs the load it places - for e.g. you have no other way of seeing which user is logged on
(and depending on your audit level) what forms and what responsibility they
are using at this time... On the other hand, ask your auditors *what* they would like to see. Oracle Apps already records Last-changed user and date/timestamp for rows, while Signon Audit tracks sessions only when it is switched on.

Let us know if you need more info.
John Kanagaraj
Oracle Applications DBA
DB Soft Inc
Work : (408) 970 7002

Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

-----Original Message-----
Sent: Thursday, October 30, 2003 11:54 AM 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: John Kanagaraj
  INET: john.kanagaraj_at_hds.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).