| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Overhead Associated with Signon Audit in Financials 11.0
Hi Vicki,
We're not running 11.03 (we're on 10.7) and we have auditing running for
sign-on audit set for Responsibility (so we get recorded what responsibility
they're using). We were running it set for User so that the DBAs could use
that information to get back who was running what. In both cases we didn't
see an appreciable decrease in performance, though we have less than 100
users who only change responsibilities a couple of times a day (at most).
We are running the "Purge Signon Audit data" concurrent manager program
daily to keep the FND tables reasonable size but we run a custom program to
move some of the data to custom tables for analysis. When we researched it,
the consensus at the time was User is best, Responsibility is OK, but
turning it on for Forms is a major impact (we didn't test as we didn't need
to know which forms people were using).
HTH
Margaret
-----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: Murray, Margaret
INET: mamurray_at_Husseyseating.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). Received on Thu Oct 30 2003 - 15:44:45 CST
 |
 |