PROTECTED]
Sent by: [EMAIL PROTECTED]
10/30/2003 07:24 PM
Please respond to
[EMAIL PROTECTED]
To
Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
cc
Subject
RE: Overhead Associated with
Signon Audit in Financials 11.0
For all the non-APPS DBAs out there...
Oracle
Kanagaraj [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/30/2003 07:24 PM
Please respond to
[EMAIL PROTECTED]
To
Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc
Subject
RE: Overhead Associated with Signon Audit in Financials 11.0
For all the non-APPS DBAs out there...
Oracle
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
It is true, auditing adds significant overhead, but not session auditing.
Significant overhead is added by DML auditing because you ad significant
amount of modified blocks to every transaction you audit, you are using space
and additional CPU cycles. It can add to much more frequent checkpoints,
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
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
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
not reflect those of my employer or customers **
-Original Message-
From: Mladen Gogala [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 30, 2003 1:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Overhead Associated with Signon Audit in Financials 11.0
It is true, auditing adds