RE: Overhead Associated with Signon Audit in Financials 11.0

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

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: hkchital_at_singnet.com.sg

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