Re: setting of audit_trail initialization parameter

  • From: Chris Dunscombe <cdunscombe@xxxxxxxxx>
  • To: "dbvision@xxxxxxxxxxxx" <dbvision@xxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 24 May 2013 11:10:31 +0100 (BST)

One problem with OS is you can't have "Extended" i.e. you don't get the SQL 
text of the statement or the values of bind variables. If you want to know what 
people have really been doing and what data they've looked at then you need 
"Extended" which works with DB and XML. We use XML,Extended



 From: Nuno Souto <dbvision@xxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx 
Sent: Wednesday, 22 May 2013, 11:38
Subject: Re: setting of audit_trail initialization parameter

On 21/05/2013 11:09 PM, Jeffrey Beckstrom wrote:
> I know what the docs say but what do people really set this to;  DB, OS or 
> XML and why?

OS here.  Easy to mine, easy to integrate with other tools for corporate 
logging, easy to manage with simple OS commands.
And no, I don't believe XML is any of that - although I'm fairly sure 
there are 13892384912391239192384 certified DBAs in India with 
8223904238409 years of experience in mining XML logs willing to work for 
peanuts.  I don't do peanuts.

Nuno Souto



Other related posts: