RE: Auditing clean slate

From: Don Granaman <>
Date: Fri, 5 Mar 2010 11:20:10 -0600
Message-ID: <>

As of 10gR2 at least (and I rather doubt it will ever change), AUDIT_SYS_OPERATIONS=TRUE *never* generates audit trail writes to AUD$, but always to OS files or XML files in audit_file_dest. If AUDIT_TRAIL=DB or OS, it writes to OS files (*.aud). If AUDIT_TRAIL=XML, it writes to XML files.

-----Original Message-----

From: [] On Behalf Of Allen, Brandon Sent: Friday, March 05, 2010 9:47 AM
To:; Subject: RE: Auditing clean slate

Does the other database also have audit_trail=db?

-----Original Message-----

From: [] On Behalf Of Terrian, Thomas J Mr CTR DLA J6DIB

I don't think this is the problem since the database next to it also has audit_sys_operations = True but generates no records in sys.aud$.

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

-- Received on Fri Mar 05 2010 - 11:20:10 CST

Original text of this message