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 27% decrease in
transactions/second and 146% of the CPU time. Of course, you are asking
about auditing vs. no auditing performance, but you could use Tom's approach to
measure performance numbers.
Also,
there is at least one document I've seen on MetaLink about moving the audit
table SYS.AUD$ from the SYS schema to avoid contention/fragmentation.
Check out Note 72460.1. Keeping your audit data in the DB, versus in OS
text files, is recommended so that you can use DB reporting features and not
have to write your own text parsing code- unless you enjoy that sort of
thing :-).
Best regards,
David B. Wagoner
Database Administrator
Arsenal Digital
Solutions
Web: http://www.arsenaldigital.com
"the most trusted
source for
STORAGE
MANAGEMENT SERVICES"
The contents of this e-mail message may be privileged
and/or confidential. If you are not the intended recipient, any review,
dissemination, copying, distribution or other use of the contents of this
message or any attachment by you is strictly prohibited. If you receive this
communication in error, please notify us immediately by return e-mail or by
telephone (919-466-6700), and please delete this message and all attachments
from your system.
Thank you.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 30, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
Subject: Overhead Associated with Signon Audit in Financials 11.0
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