Another advantage of SignOn audit [see my other email on details of my implementation],
particularly down to the FORM level, is that, given a process taking signficant CPU time,
I can actually identify *who* the user is, which *form* he is in currently.
I have job periodically running an improved version of utllockt.sql and providing User,Responsibility,Form
information by using FND_SIGNON_AUDIT_VIEW as well !
Hemant At 01:44 PM 30-10-03 -0800, you wrote:
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: [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).
Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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).
